sql-function

MySql Regular Expression Select Columns Matching (dynamic)multiple Values within Stored Procedure

I am trying to generate a query where I want to select columns(text) matching multiple values. eg: I have two columns, id and description. suppose my first row contains description column with value Google is website and an awesome search engine , second row with description column value Amazon website is an awesome eCommer...

Why does this T-SQL function always return true?

Hi I wrote this function and now its always returning true... can anybody help me? Create FUNCTION dbo.ValidateCenter ( @Center_ID nvarchar(50), @Password nvarchar(50) ) RETURNS bit AS BEGIN declare @Res bit if exists(Select * From TPasswords Where (Center_ID = @Center_ID) and (isSecurity = 0) and (Pass = @Passw...