Concat in SQL query
-
Is there a way to string together a value that is returned by a query wihtout writing function or PLSQL? Table Def: ky_remarks no_remarks_seq tx_remarks_generic For instance
select tx_remarks_generic from remarks where ky_remarks = 232323324 and no_remarks_seq > 0no_remarks_seq = numeric and allows for multipule lines of remarks. How can I string all the remarks for that key together in my SQL? Thanks TomTom Wright tawright915@gmail.com
-
Is there a way to string together a value that is returned by a query wihtout writing function or PLSQL? Table Def: ky_remarks no_remarks_seq tx_remarks_generic For instance
select tx_remarks_generic from remarks where ky_remarks = 232323324 and no_remarks_seq > 0no_remarks_seq = numeric and allows for multipule lines of remarks. How can I string all the remarks for that key together in my SQL? Thanks TomTom Wright tawright915@gmail.com
Tom Wright wrote:
Is there a way to string together a value that is returned by a query
well if your talking abt concatinating then in SQL Server u can use the + operator and in ORacle u can use the || operator to concatinate strings
Tom Wright wrote:
Tom Wright tawright915@gmail.c
giving your email likethis is an open invitation for spamers to attack your email!!!
Rocky You can't climb up a ladder with your hands in your pockets.