how to denote the like symbol % in perl program

2010-05-04 Thread Pam Wampler
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 the % sign so that oracle will know to do a like

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

2010-05-04 Thread Pam Wampler
: $sqlQuery-errstr; -Original Message- From: Steve Bertrand [mailto:st...@ipv6canada.com] Sent: Tuesday, May 04, 2010 11:44 AM To: Pam Wampler Cc: beginners@perl.org Subject: Re: how to denote the like symbol % in perl program On 2010.05.04 11:21, Pam Wampler wrote: How do you add the % sign

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

2010-05-04 Thread Pam Wampler
PM To: Pam Wampler Cc: beginners@perl.org Subject: Re: how to denote the like symbol % in perl program 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