"WHERE" to now ?? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

baldcat -> "WHERE" to now ?? (7/21/2005 1:55:53)

righto,,,

Getting the hang on this.. But have come across another little snag..

I have this SQL that filters certain data for me... Now there is a column that has 3 different entries... 'O', 'I', and 'S'
O = On order
I = In Stock
S = Sold

My SQL is as follows, 

SELECT *
FROM EMMG.VDM
WHERE stock_no LIKE 'R%' AND stk_status = ???

I did have 
stk_status = 'I'
But I need to display stuff on order as well.
So how can I just get so it filters out everything with 'S'
[:D]

[:D]



rubyaim -> RE: "WHERE" to now ?? (7/21/2005 2:05:30)

Maybe use stk_status <> 'S' ?

Worth a shot, I've got that on a query here and it works [:)]

Sally




baldcat -> RE: "WHERE" to now ?? (7/21/2005 2:17:01)

It is a beautiful thing Sal,, 

SELECT *
FROM EMMG.VDM
WHERE stock_no LIKE 'R%' AND stk_status <> 'S'


Cheers



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875