How do I exclude if text string inside string - ACCESS

#1 (**permalink**) 28-Jul-2006, 08:37 AM

In query design, for a certain column, I need to exclude all records
where the string "CDMA" appears anywhere in the string. Not sure how
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13470-how-do-i-exclude-if-text.html
to specify this??

Thank you

Wheelz

*

#2 (**permalink**) 28-Jul-2006, 08:37 AM

"Wheelz" wrote in message
<1153254022.122673.240930@75g2000cwc.googlegroups.c om>:
> In query design, for a certain column, I need to exclude all records
> where the string "CDMA" appears anywhere in the string. Not sure how
> to specify this??
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13470
>
> Thank you
>
> Wheelz
Try

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13470
not like "*CDMA*"

--
Roy-Vidar