somehow not filtering the value

sqlcurious
sqlcurious used Ask the Experts™
on
Hi I am trying to filter the value which is not like 'SR' using below statement but somehow still able to see SR000003

where service_id not like  'SR%'

Pls help, thnks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst

Commented:
Try

where upper(service_id) not like  'SR%'  

to eliminate case sensityvity issue

Software Engineer
Commented:
try

where RTRIM(service_id) not like  'SR%'

Author

Commented:
thnks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial