Counting a character values

[Ali Alhussein]

hi, how can I count the number of letters in a string and get the result in a variable,

here what Ithought,
declare @counter int
select @counter = (.... what is the code that count a string and retrun numeric value)


thanks for your help
Ali

[Jane appleby]

The built in function datalength

select @counter = Datalength(@string)


------------
Ali Alhussein at 9/15/99 12:35:57 PM


hi, how can I count the number of letters in a string and get the result in a variable,

here what Ithought,
declare @counter int
select @counter = (.... what is the code that count a string and retrun numeric value)


thanks for your help
Ali

[MAK/AnanthaKumar Muthusamy]

Hi.

select @x =( select len("anand&#34) or variable

MAK
------------
Ali Alhussein at 9/15/99 12:35:57 PM


hi, how can I count the number of letters in a string and get the result in a variable,

here what Ithought,
declare @counter int
select @counter = (.... what is the code that count a string and retrun numeric value)


thanks for your help
Ali