Additional:

If you are using an ADO statement then use the wild card %.  If you are
using an MSAccess Query then use *.

Christopher Koniges
Database/WEB Systems Programmer
Tel:  (xxx) xxx-xxxx
www.jazzysystems.com

-----Original Message-----
From: Guerrino Di Minno [mailto:GDiMinno@h...]
Sent: Thursday, March 29, 2001 12:19 AM
To: sql language
Subject: [sql_language] help with wild cards???


hi guys...

Is there such thing has a wild card I can us like...

select * from TableName where '123*'

menaing that select all rows that just start with 123...

If so can you help me with the syntax...

THANKING YOU IN ADVANCE....

Guerrino D.M.