Re: ASP & Access2k question

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 07/28/04


Date: Wed, 28 Jul 2004 09:57:36 -0400


> Select * from myTable where FIELD like "%text%"

Use ' not " for delimiting the string inside the SQL statement.

And don't use SELECT *

-- 
http://www.aspfaq.com/
(Reverse address to reply.)