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

venkatesh duddukuri

10y1.1kSQL

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

17 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tusharika T10y ago
Accepted 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

0
venkatesh duddukuri10y ago
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
0
Tusharika T10y ago
welcome Venkatesh
0
venkatesh duddukuri10y ago
Madu Tusharika

Thank you so much your's code is helpful from me

Thanks and regard's

Venkatesh D

0
Shubham Kumar10y ago
welcome venkatesh!!

if you found code is helpful so mark as accept ans it may help others
thnx
0
venkatesh duddukuri10y ago
Hai...Shubham kumar

Thank you so much your code is helpful from me

Thanks and regard's

Venkatesh D

0
Amit Kumar Singh10y ago
Actually i was running ur code in 2005..its fine now running in 2012
0
Shubham Kumar10y ago
No man i m not!! keep post your are good !!!
0
Amit Kumar Singh10y ago
Sorry Shubham if u got hurt.....i am deleting my post
0
Shubham Kumar10y ago
Don't think so i will test it after posting :)
0
Amit Kumar Singh10y ago
Shubham,When i am running ur code its gives error.....so i change and paste your code
0
Shubham Kumar10y ago
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 !!!
0
Shubham Kumar10y ago
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
+1
venkatesh duddukuri10y ago
Ok thanks
But my TL given that task

He know the answer but can't tell

Answer is their
0
Amit Kumar Singh10y ago
hey venkatesh,

No other way of finding length in sql
0
venkatesh duddukuri10y ago
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
0
Amit Kumar Singh10y ago
hey.

we can use DATALENGTH()
0