asifakhtar — 2010-05-21T23:06:12-04:00 — #1
Can someone please recommend a book or links to articles where I can learn how to insert Quotes, Pipes, %, IS, IN, LIKE, bracket and variables in Concatenated SQL query string literals?
I don’t know the syntax to write statements with string literals.
r937 — 2010-05-28T08:48:06-04:00 — #2
i should just like to point out that the plus sign is used for string concatenation only in a very small number of database systems
database systems that follow sql standards use the double pipe (||) for concatenation
esearing — 2010-05-28T05:19:38-04:00 — #3
Are you looking for something like this?
SELECT 'region and store is ' +region_name + '|' + store_name as regstore
If so, syntax may vary between databases. Also review concat() or use of ||
r937 — 2010-05-28T12:49:13-04:00 — #4
in mysql use the CONCAT function
asifakhtar — 2010-05-28T12:41:53-04:00 — #5