Semicolon in SELECT query I cannot find documentation about the usage of semi-colons in a select query, for example: 

SELECT TEST.PARTIAL_PATH + ';' + G.ICON FROM GADGETS G 
.... some inner joins...


Can somebody point to the documentation that gives some examples or try to explain it here?
This is just concatenating a semicolon between two fields. Think of it like selecting LNAME + ', ' + FNAME or something similar.

It's generally fine to have presentation layer items like this in the select list, but it's important to avoid them as predicates (anything in a join or where clause), because in SQL Server, they're not SARGable.

SQL Server uses +, which is different from other platforms, that may use || to concatenate things, which is an issue I've written about in the past.