Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Like (wildcard).. in PL/sSQL

Author  Topic 

huynhtl
Posting Yak Master

107 Posts

Posted - 2008-12-12 : 13:32:59
Hi,
I have a question, is there a way to do a between in the like code?
for example, I have codes that starts with A,B,C,D,S,1,9,3,8.
I want to use the A,B,C,D,S codes only. I know like you can only use it like this:
where codes like 'A%' or codes like 'B%'. I don't want to write so many like.
where codes between like 'A%' and 'S%'......

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-12 : 16:38:08
If your question is about PL/SQL, then you should post in an Oracle forum as this one is for Microsoft SQL Server where we use T-SQL.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -