Loading

Like usage in sql sentence

Erdinc Kolukisa

16y2.2kSQL

hey guys..i dont know where is my mistake in my sql sentence..i cant get the result when i give the variable..but it works fine without Like word..but it doesnt give the result what i need...here is my proc
ALTER procedure [dbo].[sp_SearchFirm]
(
@aranan_firma nvarchar(50)
)
as
Begin
Select firma_adi From Firmalar Where firma_adi LIKE '%@aranan_firma%'
End

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Erdinc Kolukisa16y ago
hey friends i found my mistake..i changed my proc as below
ALTER procedure [dbo].[sp_SearchFirm]
(
@aranan_firma nvarchar(50)
)
as
Begin
Select firma_adi From Firmalar Where firma_adi Like '%' +@aranan_firma+ '%'
End