Concatenate
I have a value in a column that I need combined on 1 line. I need a new row when the Id in the table changes. For exampleColumn A Column B1 Boyd1 Honaker2 SteelI need the row to be 1 Boyd, Honaker2 SteelI can get the name column to...
View Answer
| Sep 25 2008 2:37 PM GMT
| asked by
Musiclover
T/SQL, Concatenate
Trim Trailling Spaces
How do I trim trailling spaces when I concatinate 2 character fields. Like when you concat names there is a big space between the 2 names.
View Answer
| Aug 29 2008 6:38 AM GMT
| asked by
Arnelr
Concatenate, Trim
Concatenate Two Fields t-sql
I need to concatenate two fields one varchar(50) and the other varchar(12)The result I need is to see the full 50 characters of the first field even though all 50 may not be filled.Thanks
View Answer
| Jun 25 2008 3:41 PM GMT
| asked by
Jp5282
SQL Server, T-SQL, Concatenate
Sample of how to concatenate files to ftp to server
I need to be able to combine three files into one then ftp them to a remote server. Does anyone have an example?
View Answer
| Jun 25 2008 2:43 PM GMT
| asked by
Brookr
FTP, Concatenate, Remote servers
storing multiple fields iin jsp into a single column in th table
i have one text filed and a select field.I have to concatenate both of them and store into a single column in the table. how do i achieve this??
View Answer
| Jun 25 2008 9:19 AM GMT
| asked by
Jem
Concatenate, Database programming, JavaServer Pages
concatenate more than 2 fields together into one field in SQL
say I have 3 columns, 1st name, midlle name and last name, how do I merge the 3 columns into one column yet separate the content with commas
View Answer
| Jun 13 2008 2:55 PM GMT
| asked by
Sammy54
SQL Server, CSV, Concatenate
rpg sql concat
Our database was designed with separate fields for cc, yy, mm and dd. I'd like to know if and how these fields can be combined into one field then order by on that field. Is this possible? I would need to know the syntax also. If this is not possible, then is there a another way to order by...
View Answer
| Apr 16 2008 1:14 PM GMT
| asked by
Mcg
RPG, SQL, Concatenate
