var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Please Help for Function
I am looking for freequently using fuction like Find number of characters in a word.
If I use the function like getnumberofChars(@Str) Then it has to give the result is 3.
Because rest of all numeric valus.
Is we have any function like this in SqlServer
please Help me
-- Prasad --
You can use the DATALENGTH(), which will return the number of characters in a string.
If you are using that on a char datatype, you may want to use a Rtrim() on the field first before getting that datalenght.
If you are using SQL Server 2000 you could put this code into your own user defined function.
SET @Str ='AXG00X023'
SET @i = 0
WHILE @x <= DATALENGTH(@Str) BEGIN
IF ISNUMERIC(SUBSTRING(@Str,@x,1)) = 0