🚀 go-pugleaf

What Mister Daeschler said ,
it this is very important to double quote your string,....

take a look at the very usual QuotedStr() in the help file, I just can't
live without it...

bye!


D. Daeschler <illusioned@netzero.net> wrote in message
news:3be9aeac$1_2@dnews...
>
> I'm not sure if this is exactly what you're talking about, but if you make
sure that the user's input instead of having one ' has two ' (like
"o''brien") sql will treat the data as "o'brien" and will not give you an
error.
>
> Just trying to help
> - Dave
>
>
> "Formentz" <francesco@leotron.com> wrote:
> >Hi all,
> >I have a problem with the like statement in SQL Server, and the
parameters.
> >I would like to do a query like this :
> >select * from Table1 where Field1 like 'some%' + :p_other + '%'
> >but when I set the parameter and try to open the query, it returns no
result
> >set, even if the table contains the data I am searching.
> >I know I can concatenate the parameter in the string at runtime, but if
the
> >user inserts a ' character I am lost, the query will error.
> >
> >Anyone got a thing like this work?
> >
> >TIA
> >Ciao
> >    Formentz
> >
> >
>