Posted by Jason Lepack on 07/05/07 21:01

SELECT
FirstName,
LastName,
BusinessName,
MailingAddress1
FROM
tblAddresses
WHERE
FirstName LIKE '%' + ISNULL(@FirstName, '') + '%'
AND
(
LastName LIKE '%' + ISNULL(@LastName, '') + '%'
OR LastName is null
)





On Jul 5, 4:56 pm, manning_n...@hotmail.com wrote:
> I've got the following SELECT statement in a stored procedure:
>
> SELECT FirstName, LastName, BusinessName, MailingAddress1
> FROM tblAddresses
> WHERE FirstName LIKE '%' + ISNULL(@FirstName, '') + '%' AND
> LastName LIKE '%' + ISNULL(@LastName, '') + '%'
>
> If I input "tom" for @FirstName then it returns rows with "tom"
> somewhere in the first name but that row must have a last name too in
> order to be returned. How do I change this to return both types of
> rows: one with "tom" as a firstname and with a lastname and one with
> "tom" as first name but no last name?
>
> Thanks for any help or advice.

• Next in forum: Re: Need SELECT ... LIKE help, please
• Prev in forum: Need SELECT ... LIKE help, please
• Thread view: Re: Need SELECT ... LIKE help, please

[Reply to this message]