asked
problem with date in where condition
I have a table with dateofbirth column and a name column. Dateofbirth is of type date and name is a nvarchar. when i query the table select * from dbo.Table where Name = 'ss' and DateofBirth = '2011-12-03' i get the result but when i use a stored procedure to pass in the parameters , i dont get any data. Can some one explain me what i am doing wrong???!!1 SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO ALTER proc [dbo].[SearchUser](@Name nvarchar(48),@DateofBirth date) as begin select * from dbo.Table where DateofBirth= @DateofBirth and PatientName like '%@PatientName%' end
How do you pass the parameter - how's your call to the stored procedure looking?
Your problem is here: and PatientName like '%@PatientName%' You need to separate the percent from the variable and concatenate the string: and PatientName like '%' + @PatientName + '%'
Nice spot William. Waiting for @mrs_fatherjack to comment on the new avatar... ;)
