Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Help with SQL wildcard statement

Jul 21, 2003, 10:41 AM
mdj1
Enthusiast (628 posts)
Jul 21, 2003, 10:41 AM
Views: 17827
Shortcut
Quote Reply
Help with SQL wildcard statement
Hi All,

I need to pull information from a database where information in a field = a number, but not 0 so if the field has 1 - 1000 in it it will return the infomation

but if it has 0 it will skip it.

Does this make sense, and can it be one??
Regards

Mark
http://www.host4.me.uk

No doubt i'll be back for more answers!
Subject Author Views Date
Thread Help with SQL wildcard statement mdj1 17827 Jul 21, 2003, 10:41 AM
Post Re: [mdj1] Help with SQL wildcard statement 		Stealth 17249 Jul 21, 2003, 11:11 AM
Thread Re: [mdj1] Help with SQL wildcard statement 		Alex 17367 Jul 21, 2003, 1:17 PM
Thread Re: [Alex] Help with SQL wildcard statement 		mdj1 17411 Jul 21, 2003, 11:22 PM
Thread Re: [mdj1] Help with SQL wildcard statement 		mdj1 17305 Jul 21, 2003, 11:29 PM
Thread Re: [mdj1] Help with SQL wildcard statement 		mdj1 17333 Jul 22, 2003, 4:58 PM
Thread Re: [mdj1] Help with SQL wildcard statement 		Stealth 17389 Jul 22, 2003, 7:18 PM
Thread Re: [Stealth] Help with SQL wildcard statement 		mdj1 17473 Jul 22, 2003, 7:20 PM
Thread Re: [mdj1] Help with SQL wildcard statement 		Stealth 17316 Jul 22, 2003, 7:27 PM
Thread Re: [Stealth] Help with SQL wildcard statement 		mdj1 17481 Jul 22, 2003, 7:33 PM
Thread Re: [mdj1] Help with SQL wildcard statement 		mdj1 17368 Jul 22, 2003, 7:39 PM
Thread Re: [mdj1] Help with SQL wildcard statement 		Stealth 17330 Jul 22, 2003, 7:43 PM
Thread Re: [Stealth] Help with SQL wildcard statement 		mdj1 17332 Jul 22, 2003, 7:52 PM
Thread Re: [mdj1] Help with SQL wildcard statement 		Stealth 17295 Jul 22, 2003, 8:11 PM
Thread Re: [Stealth] Help with SQL wildcard statement 		mdj1 17303 Jul 22, 2003, 9:48 PM
Post Re: [mdj1] Help with SQL wildcard statement 		mdj1 17221 Jul 22, 2003, 10:07 PM