Ignoring first few characters in a TSQL Select

• Ash-N

  Say Hey Kid

  Points: 703

  More actions

  April 20, 2007 at 12:02 pm

  #370607

  I have a SQL that get me a count of rows that have a column name = the parameter that i am passing in.

  SELECT COUNT(*) FROM Content_T WHERE Name = $[[=] CName]

  Some of the values for Name in the database have a prefix attached to them "AUTO_" that i need to ignore. How i modify my SQL to ignore the prefix "AUTO_". Please note that not all the Name columnshave the AUTO_ prefix. If the name column do not have AUTO_ prefix i need do a regular match.

   

  Thanks for hte help

• Sean May-415583

  SSC Enthusiast

  Points: 144

  More actions

  April 20, 2007 at 12:32 pm

  #701792

  where replace(myName, 'AUTO_', '')  = @thisName

  or

  where CASE WHEN LEFT(myName, 5) = 'AUTO_' THEN RIGHT(myName, LEN(myName) - 5) ELSE myName END = @thisName

• Ash-N

  Say Hey Kid

  Points: 703

  More actions

  April 20, 2007 at 12:43 pm

  #701795

  Thanks it worked...