Sql server query syntax left() function
Posted on 2013-10-22
My goal: Select all records from table Part_Serial_Number, column Part_No, where the first character of Part_No = "P" and create a new table PS_Serial_Number with those records.
My current query fails with "Invalid column name "P":
WHERE (LEFT(Part_Serial_Number.Part_No,1)) = "P"
Part_No is type nvarchar
I know this must be obvious, but I'm floundering...