Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL VB(ADO)
oracle sql (&plsql) delineate strings with the appostrophe (single quote)
try
SELECT * FROM tblX WHERE strVar= 'SOMESTRING' ;
hth
Chr. Wounlund wrote in message <77mn0u$23a4$1_at_news-inn.inet.tele.dk>...
>Hi all
>
>I have a minor problem (read dumb question) with sending sql strings to an
>oracle database. The connection works, however I want to do a SELECT with a
>WHERE condition based on a string selection. Something like this:
>
>SELECT * FROM tblX WHERE strVar="SOMESTRING";
>
>I can get it to work with an access database, but in terms of ORACLE--no
>luck yet.
>
>Any help would be appreciated ...
>
>Sincerly
>
>Christian
>
>
Received on Fri Jan 15 1999 - 20:19:50 CST