Tony Septav
TSeptav at uniserve.com
Fri Feb 24 11:39:18 CST 2012
Hey Lambert Thanks kindly. Seems to be doing the trick. Last piece of the puzzle solved. Tina you were kind of on the right track. Found this (I like to understand what I am doing) [] used to escape reserved keywords used as identifiers Eg. SELECT [select] FROM test Tony Septav Nanaimo, BC Canada -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Friday, February 24, 2012 9:00 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Asterix Gary provided the solution... Like "*[*]" Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav Sent: Friday, February 24, 2012 11:49 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Asterix Hey Tina Thanks Sorry but I do not understand what the escape character is that you are referring to and therefore how to use it. Tony Septav Nanaimo, BC Canada -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris Fields Sent: Friday, February 24, 2012 8:45 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Asterix Hi Tony, Well, lets see, won't the escape character \ take care of that? What happens when you do that? T Tina Norris Fields tinanfields at torchlake.com 231-322-2787 On 2/24/2012 10:51 AM, Tony Septav wrote: > Hey All > Does anyone know how do you search for an * in a string using SQL. I > have got it working for& and " but the * has got me stumped. > > Thanks > Tony Septav > Nanaimo, BC > Canada -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.1913 / Virus Database: 2114/4829 - Release Date: 02/24/12 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.1913 / Virus Database: 2114/4829 - Release Date: 02/24/12