[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
>