[AccessD] how can i do this? - addition

Hello Andy,

thanks,
i am just back at home and will try it out monday at work.

Best Wishes

Pedro



----- Original Message ----- 
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, August 22, 2008 11:10 AM
Subject: Re: [AccessD] how can i do this? - addition


> Pedro
>
> That'd be
>
> WHERE Instr(1,[Diag1],[RapNaam])<>0
>
>
> Or if Diag1 may be null you'd need
>
> WHERE Nz(Instr(1,[Diag1],[RapNaam]),0)<>0
>
>
>
> -- Andy Lacey
> http://www.minstersystems.co.uk
>
>
>
>>-----Original Message-----
>>From: accessd-bounces at databaseadvisors.com
>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>>pedro at plex.nl
>>Sent: 22 August 2008 11:03
>>To: accessd at databaseadvisors.com
>>Subject: [AccessD] how can i do this? - addition
>>
>>
>>I have the query, but i just need to now what i can use as
>>operator in the WHERE statement to search on part of a value
>>of a field??
>>
>>Pedro
>>-- 
>>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
>