How Remove Last value from variable in ms sql

Asked May 19 '20 at 12:07

Active May 19 '20 at 12:17

Viewed 26 times

How to remove last value with comma, I want to take recored only 5

declare @brokername1 nvarchar(max)='indiabullssecurities,canmoney,indianivesh,acumencapitalmarket,sharekhan,edelweisscapital';
print @brokername1

I want this string 'indiabullssecurities,canmoney,indianivesh,acumencapitalmarket,sharekhan'

edited May 19 '20 at 12:17

Dale K

asked May 19 '20 at 12:07

Sajid Khan

reverse it, find the index of the first comma then take the characters from there to the end then reverse it back – cameront May 19 '20 at 12:12
This should help - https://stackoverflow.com/questions/39002025/is-there-a-lastindexof-in-sql-server. – nickfinity May 19 '20 at 12:12
@cameront can you please share perfect answer. – Sajid Khan May 19 '20 at 12:18
Did you look at the link I shared? ```select left(@brokername1, len(@brokername1) - charindex(',', reverse(@brokername1) + ','))``` – nickfinity May 19 '20 at 12:25
Thansk @nickfinity – Sajid Khan May 21 '20 at 07:34

0 Answers0