in reply to Perl/DBI/Oracle and strings with spaces

rather than
SELECT this FROM that WHERE foo=$findthis
try
SELECT this FROM that WHERE foo LIKE $findthis this is especially useful in date fields.

Replies are listed 'Best First'.
Re: Re: Perl/DBI/Oracle and strings with spaces
by Fastolfe (Vicar) on Dec 10, 2000 at 09:34 UTC
    Don't do this if you don't have a valid reason to do it. If you are wanting/expecting a string to match exactly to what's in the database, you're far better off checking for equality than LIKEness.
[reply]

In Section Seekers of Perl Wisdom