🚀 go-pugleaf

Thanks again

I might have to bite the bullet and update the definition and related code.

Quinn I will try the extract, Thanks
"Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> wrote in message 
news:464088c2@newsgroups.borland.com...
> Craig Cookesley wrote:
>>
>> I need to update a field defined as varchar(8) with a datetime field
>> in a trigger
>>
>> The field is used extensive in code so to change the field type would
>> be a big job
>>
>> i was hoping to cast or convert the datatime field to string before
>> update
>
> Use cast.
>
> Update table set somefield = cast(current_date as varchar(8)) where 
> <condition>
>
>
> -- 
> Wayne Niddery - Winwright, Inc (www.winwright.ca)
> "Some see private enterprise as a predatory target to be shot, others
> as a cow to be milked, but few are those who see it as a sturdy horse
> pulling the wagon." - Winston Churchill
>