sql server2000, counting characters in a string 1

[duchovnick]

Hi,
I have a string which i want to be displayed only if its' number of characters is greater then,
say, five. My code is:

SELECT
CASE number_of_characters(mytable.mystring)
WHEN GT 5 THEN mytable.mystring
END

can anyone help me with the right code to:

number_of_characters(mytable.mystring)

?
Thanks

 

[onpnt]

something like

IF (select len('test')) > 3
 BEGIN
  PRINT 'something'
 END

LEN() function

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[duchovnick]

Thanks a lot!

 

[onpnt]

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}