Last post Sep 23, 2010 10:04 PM by jessajr
Sep 23, 2010 03:36 AM|jessajr|LINK
How can I make this work since when I do this in asp.net, I'm having problem but in mysql query builder it's working fine.
SELECT CONCAT(employee.LastName,', ',employee.FirstName,' ',SUBSTRING(employee.MiddleName,1,1),'.') FROM employee
Sep 23, 2010 12:45 PM|sansan|LINK
Did you debug and see what's the string that's being passed into the command text in your code?
In a simpler way, you can use + to append columns of varchar type
SELECT employee.LastName + ' , ' + employee.FirstName +' ' + SUBSTRING(employee.MiddleName,1,1)+'.' FROM employee
Sep 23, 2010 10:04 PM|jessajr|LINK
Thanks for your immediate feedback but I already try this and output is 0. This is the syntax for MSSQL.