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
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