query to find out how many times 'L' has occurred in “SQL CLASSES”

• adc22

  Old Hand

  Points: 338

  More actions

  September 21, 2009 at 9:21 am

  #204880

  wanted to know how to count a letter in a sample string in SQL 2000

• Mark Cowne

  One Orange Chip

  Points: 26952

  More actions

  September 21, 2009 at 9:28 am

  #1056320

  declare @s-2 varchar(30)

  set @s-2= 'SQL CLASSES'

  select len(@s) - len(replace(@s,'L',''))

  ____________________________________________________

  Deja View - The strange feeling that somewhere, sometime you've optimised this query before

  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537