Concatenation Operator

[murray83]

Below code is almost perfect but for just one addition where i have it SUBSTR i want it then to CONCANT the numbers into one nice string

have tried google and after reading a few articles tried adding the CONCANT but it just went into error so any help would be great cheers

SELECT DISTINCT

Container_Id, From_Loc_Id, Final_Loc_Id, Priority, Task_Type, SUBSTR(Consignment,11,4)

FROM 

Move_Task

WHERE

-- Task Type T = Marshall

Task_Type = 'T' AND Final_Loc_Id LIKE 'HRS%'

ORDER BY Priority DESC

 

[moke123]

http://allenbrowne.com/func-concat.html

 

[arnelgp]

there is no Substr() function in VBA (maybe foxpro or Dbase have).
its equivalent is Mid() in vba.

 

[murray83]

there is no Substr() function in VBA (maybe foxpro or Dbase have).
its equivalent is Mid() in vba.

thats SQL and i can say it does work

 

[arnelgp]

sorry. its transact sql.
its not Concant, should be Concat(). this function is available starting with mssql 2012.