check the last position of the field 1

[deswalker]

Help! I'm a newbie, working via query analyzer

I need to pull as claims where the service code ends in "T" on a varchar(6) field. The 6 th position is blank in many of the rows. the code could end at any position.

 

[vongrunt]

select *
from claims
where serviceCode like '%T'

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[SQLSister]

select * from claims where right(service code,1) = 'T'

Questions about posting. See faq183-874
Click here to help with Hurricane Relief