Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatanate

Status
Not open for further replies.
bugzLue

bugzLue

IS-IT--Management
Feb 27, 2001
57
0
0
US
I have a Auto number that I want to concatanate this text
I have tried this code but it will not work. please help.

this was
SELECT
(id(cast id as char)+' '+species+' '+genera+' '+cultiver)

From plants

AND THIS WAY
I get the text to concatanate

SELECT
Cast (id as CHAR) ID, (species+' '+genera+' '+cultiver)

From plants Live to learn or die trying
 
Sort by date Sort by votes
Try to replace + with &

[pipe]
Daniel Vlas
Systems Consultant
danvlas@yahoo.com
 
Upvote 0 Downvote
THANK YOU THANK YOU
That was it

Thank you Live to learn or die trying
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top