SP

[mayu03]

Is it possible to do in one statement?
I have a sp where I am passing 2 param:
@lastName and @ID. Some times ID can be empty and I
need to select based on lastname, if Id is not empty select
spesific record. My 'or' and 'And' is not working correct.
Can you help me?
SELECT *
FROM Table1
WHERE NameLast LIKE @lastName or ID='@id

 

[JohnDTampaBay]

How about this:

SELECT *
FROM  Table1
WHERE (
   (@id IS NOT NULL AND ID = @id)
   OR
   (@id IS NULL AND NameLast LIKE @lastName)
      )

--Angel
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)