RE: SQL Question

["Andy Nolen-Parkhouse" <aparkhouse@xxxxxxxxx>]

Cyndi,

The text below is from the SQL Programming Concepts manual.  It sounds as
though you're looking to use 'LIKE'.

I hope this is helpful.

Regards,
Andy Nolen-Parkhouse

<Quote>
LIKE says you are interested in rows in which a column value is similar
to the value you supply. When you use LIKE, SQL searches for a character
string similar to the one you specify. The degree of similarity is
determined by two special characters used in the string that you include
in the search condition:

_ An underline character stands for any single character.

% A percent sign stands for an unknown string of 0 or more characters. If
the percent sign starts the search string, then SQL allows 0 or more
character(s) to precede the matching value in the column. Otherwise, the
search string must begin in the first position of the column.
</Quote>

> -----Original Message-----
> From: midrange-l-admin@midrange.com [mailto:midrange-l-
> admin@midrange.com] On Behalf Of Cyndi Bradberry
> Sent: Thursday, January 02, 2003 12:08 PM
> 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.