Re: how to denote the like symbol % in perl program

2010-05-04 Thread Steve Bertrand
On 2010.05.04 11:21, Pam Wampler wrote: How do you add the % sign in a perl program, if you are doing an oracle query in the program? Example select date, name from my_table where name like upper(?)% The question mark would allow the user to enter the name - and I need to append

RE: how to denote the like symbol % in perl program

2010-05-04 Thread Pam Wampler
Here's the code -- I'm just learning perl so any help is greatly appreciated It will work if I have the user input something like pam% with the percent sign...but I really just want the user to have to enter pam and have the program append the %percent sign #!/usr/bin/perl -w use DBI;

Re: how to denote the like symbol % in perl program

2010-05-04 Thread Steve Bertrand
On 2010.05.04 12:11, Pam Wampler wrote: Here's the code -- I'm just learning perl so any help is greatly appreciated It will work if I have the user input something like pam% with the percent sign...but I really just want the user to have to enter pam and have the program append the

RE: how to denote the like symbol % in perl program

2010-05-04 Thread Pam Wampler
That worked Thank you so very much...I have been beating my head against the wall on this one. Thanks for helping while I am trying to learn perl!!! Have a great day! Pam -Original Message- From: Steve Bertrand [mailto:st...@ipv6canada.com] Sent: Tuesday, May 04, 2010 12:19