Please help me....

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  October 10, 2009 at 6:38 am

  #212156

  I have a column Description

  EX:

  Description having the values "Welcome@to@Technology"

  I need to count how many @symbols are in that word..

  please help me to know urget

• Mark Cowne

  One Orange Chip

  Points: 26952

  More actions

  October 10, 2009 at 6:41 am

  #1064457

  DECLARE @s-2 VARCHAR(100)

  SET @s-2='Welcome@to@Technology'

  SELECT LEN(@s)-LEN(REPLACE(@s,'@',''))

  ____________________________________________________

  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

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  October 10, 2009 at 6:44 am

  #1064458

  Thanks tooo...