Steve
> SELECT type_id, type_id & ' (' & description & ')' AS temp
> FROM CallTypes
> WHERE new
> ORDER BY sequence
Is this a literal excerpt?
"WHERE new" doesn't make sense to me. It should be WHERE something =
something else.
"ORDER BY sequence" doesn't either - "sequence" isn't in the SELECT clause.
Also, if type_id is a numeric field, it would be better to cast it to a
character type before using it in a concatenation.
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
