Thanks, I knew it was simple, what I have to do was create a variable vcommand and execute that.
Thanks again, Paul -----Original Message----- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Wednesday, April 13, 2016 12:08 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Like/Contains Question At 11:40 AM 4/13/2016, Paul Buckley wrote: >I'm using the latest 9.5(64) and having a brain freeze this morning. >I'm trying to do an edit using where all the values of a column begin >with the letter P. I've tried > >edit all from customer where firstname contains 'P%' >edit all from customer where firstname like  'P%' Paul, FWIW ... The fist statement is looking for the exact characters "P%". The second statement should work accordingly when searching for the text that starts with "P". However ... Make sure to verify the QUOTES setting for your connected database. SHOW CHAR Hope that provides you with some blue's clues ... Very Best R:egards, Razzak. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.