ON SUBSTRING (ERR.FIRSTNAME,1,3) = SUBSTRING (DEM.FIRSTNAME,1,3) --NOTE- IT WILL ONLY TRY TO MATCH 1ST 3 CHARACTER ON BOTH TABLES AND THAT WILL BE THE SAME --NOTE- IT WILL HELP BCZ PEOPLES NAME'S ...

Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...

select substring (FirstName , 1,5) from Person.Person where BusinessEntityID = 3 -- Person.Person tablosunda ki BusinessEntityID si 3 olanı bana getir. Id si 3 olanın Firstname kolonunun 1. ve 5.

I'm having to hack a report together to pull data from another field in the same table. The row selection is going to be based on various elements in the above 'foreignkey' field - elements 1, 2, 4 & ...

I have a column of data with values resembling this: HL7_Result_for_Message_ID_123Q324343.hl7 I need to grab that ID number (in bold), the challenge being that it can be any and all lengths. I have ...