SQLize Online / PHPize Online  /  SQLtest Online

select TRIM( CONCAT( COALESCE(Title + ' ', ''), FirstName + ' ', COALESCE(MiddleName + ' ', ''), LastName ) ) as Name, TRIM( CONCAT( AddressLine1 + ', ', COALESCE(AddressLine2 + ', ', ''), City + ', ', StateProvince + ', ', PostalCode ) ) as Address from Customer c join CustomerAddress ca on ca.CustomerID = c.CustomerID join Address a on a.AddressID = ca.AddressID where StateProvince = 'Texas' order by LastName ; SELECT 'Last_query_cost' AS [Variable_name], dbo.ufnGetQueryCost('select TRIM( CONCAT( COALESCE(Title + '' '', ''''), FirstName + '' '', COALESCE(MiddleName + '' '', ''''), LastName ) ) as Name, TRIM( CONCAT( AddressLine1 + '', '', COALESCE(AddressLine2 + '', '', ''''), City + '', '', StateProvince + '', '', PostalCode ) ) as Address from Customer c join CustomerAddress ca on ca.CustomerID = c.CustomerID join Address a on a.AddressID = ca.AddressID where StateProvince = ''Texas'' order by LastName') AS [Value];