Robert Hicks wrote:
I have a large array of numbers that I need to use in an update SQL
statement using a "like" clause.
my @nums = ( 123 456 789 );
foreach my $num (@nums) {
$dbh->do(q{update table_name set item_desc1 = item_desc2 where equip
like # I draw a blank here
}
I am not sure how to use the $num in a like since a like is '%' and it I
do '%$num' that won't be ierpolated.
Help...
Robert
Never mind...I was mixing my SQL thoughts with my Perl thoughts and
coming up blank.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
