Posted by debian mojo on 10/01/61 11:19

Yes it is possible!

Do it this way!

eg :-

declare @flen int
set @flen = 10

exec('select cast(somefield as char(' + @flen + ')) as newfield into
newtable
from oldtable')


Regards
Debian

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: exclude query
• Prev in forum: exclude query
• Thread view: Re: Programming Field Lengths

[Reply to this message]