Posted by Chris H on 09/04/07 19:04

Shiju,

Thanks - the working (and streamlined) query becomes:

select (rtrim(description)+' '+convert(char(20),open_date,101)) as
description from oncd_opportunity where opportunity_id=?

Much more elegant - thanks!

• Next in forum: Re: Changing data-types
• Prev in forum: Database replication
• Thread view: Re: String/Date Concatenation causes conversion error - streamline fix suggestions

[Reply to this message]