Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I just need help with syntax 1

Status
Not open for further replies.
mrblonde

mrblonde

Technical User
Mar 16, 2001
187
US
How can you select a record that is not null and not a space?

I have:

AND CustTicket IS NOT NULL AND CustTicket IS NOT ''

Anyone?
 
Sort by date Sort by votes
AND isnull(CustTicket, '$$$' ) <> '$$$' AND CustTicket<>''

(i presume CustTicket is char)
'$$$' is just a sample string, any string that is never a valid CustTicket is oke.
br
Gerard
(-:

Better a known bug then a new release.


| Do it!
|
V
 
Upvote 0 Downvote
AND CustTicket IS NOT NULL AND CustTicket <> ''

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

f0rg3tfu1
  • Locked
  • Question
PLSQL Package Help
Replies
0
Views
202
f0rg3tfu1
f0rg3tfu1
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
506
Chris Miller
Chris Miller
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
623
Chris Miller
Chris Miller
Billz66
  • Locked
  • Question
need to udate table entry with number containing a *
Replies
11
Views
196
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
343
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top