without using len() function find out the length of the text

Question

hai..... write stored procedure in sql without using len() function find out the length of the text. using substring() or Charindex() or Stuff() functions Thanks Venkatesh D

Tusharika T · Answer

hii, you can also use below query declare @t varchar(10),@var VARCHAR(max)='@test123'; declare @t1 int=1,@t2 varchar(10); while(SUBSTRING (@var, @t1, 1)!=' ') begin set @t1=@t1+1 set @t=SUBSTRING (@var, @t1, 1); if(@t='') begin select @t1-1; return; end end

Shubham Kumar · Answer

Hi venkatesh i just write on the go try if you find something helpful just pass any string at place of ABC12 DECLARE @A VARCHAR ( max )= 'ABC12' , @myChar VARCHAR (2)= '@' , @repVal VARCHAR ( max ) SET @repVal= REPLACE (@A, '@' , '_' ) SET @repVal=@repVal+@myChar SELECT CHARINDEX( '@' ,@repVal)-1

venkatesh duddukuri · Answer

hai....shubham kumar i don't know how to write the Procedure name: Table name: column name: data type : below URL address Plz send one example www.getsqlquery.com Thanks and Regard's Venkatesh D

Tusharika T · Answer

welcome Venkatesh

venkatesh duddukuri · Answer

Madu Tusharika Thank you so much your's code is helpful from me Thanks and regard's Venkatesh D

Shubham Kumar · Answer

welcome venkatesh!! if you found code is helpful so mark as accept ans it may help others thnx

venkatesh duddukuri · Answer

Hai...Shubham kumar Thank you so much your code is helpful from me Thanks and regard's Venkatesh D

Amit Kumar Singh · Answer

Actually i was running ur code in 2005..its fine now running in 2012

Shubham Kumar · Answer

No man i m not!! keep post your are good !!!

Amit Kumar Singh · Answer

Sorry Shubham if u got hurt.....i am deleting my post

Shubham Kumar · Answer

Don't think so i will test it after posting :)

Amit Kumar Singh · Answer

Shubham,When i am running ur code its gives error.....so i change and paste your code

Shubham Kumar · Answer

Hi amit its a bad manner to copy and paste someone else code, other user get confuse to which are correct . i know you are good !!!

venkatesh duddukuri · Answer

Ok thanks B ut my TL given that task He know the answer but can't tell Answer is their

Amit Kumar Singh · Answer

hey venkatesh, No other way of finding length in sql

venkatesh duddukuri · Answer

sorry, i was used that function but here the question is we should not use len or datelength. By using of 'rowindex()' or 'charindex()' is there any syntax can you let me now Thanks and regard's Venkatesh D

Amit Kumar Singh · Answer

hey. we can use DATALENGTH()