Monday 14 April 2014

Get Character Index in sql server

1-Get Index of character
select CHARINDEX('FindWhat','String expression')
select CHARINDEX('1','0001')

Result-4

2- Get character of particular Index
select CHARINDEX('FindWhat','String expression',Index)

select CHARINDEX('1','000000000',1)
Result-0
select CHARINDEX('1','100000010',1)
Result-1
select CHARINDEX('1','100000010',2)
Result-8




No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...