truncation

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

If, in this case, you are always looking for the first 4 characters, use SUBSTRING or LEFT. I would just use substring: substring('2006-zzzz', 1, 4)

phamm Say Hey Kid Points: 679 More actions · Answer 2

Thanks Lynn, actually I am looking for a statement that would give me a result before the dash because the number before the dash (-) could vary.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Try this:

select substring('2006-zzzz', 1, patindex('%-%', '2006-zzzz') - 1)

You would actually replace the hardcoded string with a variable or column name.

phamm Say Hey Kid Points: 679 More actions · Answer 4

Say Hey Kid

Points: 679

April 9, 2007 at 8:51 am

Thanks Lynn. It worked perfect.