String - SQL Server Forums

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

SQL Server 2000 Forums

Transact-SQL (2000)

String

Author

Topic

MarioK
Starting Member

20 Posts

Posted - 2005-03-11 : 13:15:57

Hi all,
Can everyone show me how to write this query below, please? thanks.

table : Debtor
column : Finishcode
29 wrong
30 wrong number/debtor unknown
54 wrong party-don't call again
62 disco
35 filing bk

I want the output look like this:

30 wrong number/debtor unknown
54 wrong party-don't call again
62 disco

Mariok

X002548
Not Just a Number

15586 Posts

Posted - 2005-03-11 : 13:29:05

SELECT * FROM Debtor
WHERE FinishCode LIKE '30%'
OR FinshCode LIKE '54%'
OR FinshCode LIKE '62%'

Brett

8-)

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-03-11 : 13:30:58

of course

select * from MyTable where [column] not in (29, 35)

for anything better you'll need to be more specific.

Go with the flow & have fun! Else fight the flow

MarioK
Starting Member

20 Posts

Posted - 2005-03-11 : 14:27:12

its really work awesomessssss>>>
thanks Brett and Spirit1

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources