more useful options | |
PerlMonks |
Re: DBI Questionby cadfael (Friar) |
on Jan 17, 2001 at 20:59 UTC ( [id://52543]=note: print w/replies, xml ) | Need Help?? |
I am trying to find out if a SQL wildcard ('%') can be used
in a DBI script next to a placeholder.
Something like this:
$sth = $dbh->prepare( "SELECT name FROM people WHERE name LIKE ?%" );
I do this on a regular basis without needing to escape the
'%' character, but in Sybase (and I assume MS SQL Server)
, a string with a wildcard needs
to be quoted:
-----
In Section
Seekers of Perl Wisdom
|
|