A) StringConcat function information not avalable in documentation ? using SQL wizard editor i have this StringConcat(<string>, <separator>, <string>) using the documentation String SQL function , i don't find the definition of StringConcat location ( use here) ! Is there inside the documentation some information about StringConcat ( argument , return value ) ? B) concat column text best way ? What is the best way to concat column value with a seprarator ? 1) use StringConcat ? with StringConcat could we do mix StringConcat([rg], ",", [b]) and rg=StringConcat([r], ",", [g]) so we have StringConcat(StringConcat([r], ",", [g]), ",", [b]) 2) use expression StringConcat inside column name schema ? 3) use expression CAST() NVARCHAR in column name shema ? CAST (''+[red]+','+[green]+','+[blue] AS NVARCHAR) C) remove whitespace edge and inside a nvarchar Strange i use : UPDATE [tablename] SET [col1]= StringTrim([col1],' ') and space(s) are not remove for example " 23" or " 0" for any value like "454" it is ok !! . the white space perhaps is not a space so i really don't know howto remove this whitespace t !! what is the best way to remove many space(s) that are continuous " " in begin and end of a string ? here " "="space"="x" for see in html the number of space Does transform gui can convert "x454xxx0xx76x" to "454x0x76" or "454 0 76" D) Does TRansform Expression support FUNCTION END; ? seem not ! Attachments: space_not_remove.png
Book about Science , cosmological model , Interstellar travels Boyle surface fr ,en |