RE: SQL Question

"If" I understand your question, would a where portion look similar to the
follow:
where idesc like '%GOLD%'

In an interactive sql to select items that contain gold in
the item description - that works.



HTH
Mark

-----Original Message-----
From: midrange-l-admin@midrange.com
[mailto:midrange-l-admin@midrange.com]On Behalf Of Cyndi Bradberry
Sent: Thursday, January 02, 2003 11:08 AM
To: 'MIDRANGE-L@midrange. Com' (E-mail)
Subject: SQL Question


A co-worker has just asked what to use as a variable replacement character
in a select statement.  I can't find anything in any manual. Is there such a
thing ?

For example in dos you could type DEL *.* and it would delete everything.
What do you use in SQL to imitate the * in the previous dos statement ?

Thanks,

Cyndi B.
Boise, ID
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.