Search String Help Please - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Search String Help Please

Author

Topic

BenMax
Starting Member

7 Posts

Posted - 2002-05-23 : 10:33:15

Hi everyone,

I have a search string that I cannot get to work for the life of me. And please believe, a SQL master I aint lol

I have two seperate table with people names and contact information in them. I want to be able to use one search field on my web page to search both table for peoples names.

The last name in my first table is 'LastName'
The last name in my second table is 'SF_Last'
The text field that searches for them is 'txtLastName'

Could someone please point me in the right direction? I am really stumped on this one.

Thanks a ton,
Ben M

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2002-05-23 : 10:44:28

select FirstName, LastName from <table1> where LastName = txtLastName
union
select SF_First, SF_Last from <table2> where SF_Last = txtLastName

BenMax
Starting Member

7 Posts

Posted - 2002-05-23 : 11:16:28

Yellow Bug,

Thanks so much for your help. It worked of course.

Ben M

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources