dbTalk Databases Forums  

Like statement

comp.databases.ms-access comp.databases.ms-access


Discuss Like statement in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
kevcar40
 
Posts: n/a

Default Like statement - 11-16-2010 , 06:50 AM






Hi
is it possible to look for 2 different words in a body of text using
the like statement

thanks

kevin

Reply With Quote
  #2  
Old   
ngs
 
Posts: n/a

Default Re: Like statement - 11-16-2010 , 08:07 AM






"kevcar40" <kevcar40 (AT) btinternet (DOT) com> skrev
Quote:
Hi
is it possible to look for 2 different words in a body of text using
the like statement
Yes

"YourString LIKE Word1 OR Like Word2"

Bjarne

Reply With Quote
  #3  
Old   
Douglas J Steele
 
Posts: n/a

Default Re: Like statement - 11-16-2010 , 04:00 PM



That's not a valid statement.

It should be

YourString LIKE Word1 OR YourString Like Word2

Of course, it makes no sense to use Like unless you have wildcards in Word1
and Word2.


"ngs" wrote in message
news:4ce29013$0$56773$edfadb0f (AT) dtext02 (DOT) news.tele.dk...


"kevcar40" <kevcar40 (AT) btinternet (DOT) com> skrev
Quote:
Hi
is it possible to look for 2 different words in a body of text using
the like statement
Yes

"YourString LIKE Word1 OR Like Word2"

Bjarne

Reply With Quote
  #4  
Old   
ngs
 
Posts: n/a

Default Re: Like statement - 11-17-2010 , 04:19 AM



Y a right...
My statement not tested...
Bjarne

"Douglas J Steele" <NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> skrev
Quote:
That's not a valid statement.

It should be

YourString LIKE Word1 OR YourString Like Word2

Of course, it makes no sense to use Like unless you have wildcards in
Word1 and Word2.


"ngs" wrote in message
news:4ce29013$0$56773$edfadb0f (AT) dtext02 (DOT) news.tele.dk...


"kevcar40" <kevcar40 (AT) btinternet (DOT) com> skrev
Hi
is it possible to look for 2 different words in a body of text using
the like statement

Yes

"YourString LIKE Word1 OR Like Word2"

Bjarne

Reply With Quote
  #5  
Old   
kevcar40
 
Posts: n/a

Default Re: Like statement - 11-17-2010 , 06:30 AM



On Nov 17, 10:19*am, "ngs" <bsnbsn_SNABELA_ofir.dk> wrote:
Quote:
Y a right...
My statement not tested...
Bjarne

"Douglas J Steele" <NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> skrev



That's not a valid statement.

It should be

YourString LIKE Word1 OR YourString Like Word2

Of course, it makes no sense to use Like unless you have wildcards in
Word1 and Word2.

"ngs" *wrote in message
news:4ce29013$0$56773$edfadb0f (AT) dtext02 (DOT) news.tele.dk...

"kevcar40" <kevca... (AT) btinternet (DOT) com> skrev
Hi
is it possible to look for 2 different words in a body of text using
the like statement

Yes

"YourString LIKE Word1 OR Like Word2"

Bjarne- Hide quoted text -

- Show quoted text -
thanks to all
will try now

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.