🚀 go-pugleaf

Do an SQL statement like the following...

SELECT field_names FROM tbl_name
Where search_field LIKE '%search_string%'

the LIKE statement finds a specific string in a field.  The % sign works
like a wildcard character to find variations.  
Ex.
...LIKE '%ME%'
	returns "Go hoME", "ME and you", and "Have a MErry Christmas"

...LIKE 'ME%'
	returns only "ME and you"

...LIKE '%ME'
	returns only "Go hoME"

etc.

Be sure and use the single quotes around the expression you're searching
for!

As far as literature...  I just use the SQL Help files with MS Access and
SQL Server...

Good luck,
JJ


Antonio Masse <masse@axp15.iie.org.mx> wrote in article
<34845596.6B5F@axp15.iie.org.mx>...
> Hello There!
> 
> 	I am brand new on these database matters. I need to look for a string
> on all the rows of a table in a specific field, let�s say I want to look
> fo all the rows whose field NAME contains the word "isolation". Would
> you be so kind to tell me how to do that, or better, could you reccomend
> me some literature to know how to deal with this sort of things, Thanks
> beforehand,
> 
> Antonio Masse.
>