Re: String Concat in SQL?

On Jul 18, 8:51pm, Michael S. Verrilli wrote: > Subject: String Concat in SQL? > Anyone know the syntax (if there is one) for concatting strings > in SQL? I can do it in ACE but it would be a lot easier to > update tables from SQL. > > Thanks in advance for the help. > >-- End of excerpt from Michael S. Verrilli Michael, I think your looking for the '||' string concatenation operator which you can use to concatenate strings in sql, for example.. update <table_name> set <column_a> = "test "||"string"; or if you want the result of some columns, say to join the customers first and last names to make up their full name you can do something like... update customer set full_name = first_name||last_name; Hope this helps but email me if you have any problems. -- Cheers Phone: 0131-479-1271 sandys EMail: sandys@easter.euro.csg.mot.com "I have ruined Glencoe." Colonel Sir John Hill, Feb 14 1692.