Problem with Like Operator 1

[FastJimmy]

I have a table that I must search for a persons name. I have the fields nameFirst and nameLast in this table. I need to find someway to join the info for those two fields together so I can do a statement such as:

where
[full name] like '%searchValue%'

But sadly, I have no idea how to search both those fields combined info for a string.

Example: I'm search for string 'Jimmy Winter'
I can't search just the nameFirst field for that because 'Winter' is no where in it. And I can't search the nameLast field because 'Jimmy' is nowhere in it. Any help would be greatly appreciated!!

Thanks!

Jimmy

 

[Cagliostro]

Just use:
...
where
nameFirst like 'xxx' and nameLast like 'yyy' John Fill

ivfmd@mail.md

 

[FastJimmy]

John, I tried this:

Where nameFirst like '%#form.searchValue#%' AND
nameLast like '%#form.searchValue#%'

And it returned no results. Anyone have anymore ideas?

Thanks a lot!

Jimmy

 

[Rohdem]

How about:
WHERE ([firstname] & [lastname]) Like 'searchValue'
Mike Rohde
rohdem@marshallengines.com
"If builders built buildings the way programmers wrote programs, the first woodpecker to come along would destroy civilization!"

 

[Cagliostro]

try
...
where (namefirst + ' ' + namelast) like ('*' + form.searchvalue + '*') John Fill

ivfmd@mail.md

 

[FastJimmy]

Thanks a lot John and Mike!! Problem solved! I appreciate it!

Jimmy