[DUG] Change a VarChar(255) into a VarChar(20) - Firebird

[Phil Middlemiss]

I have an Firebird database with a field that stores a small string 
value in a VarChar(255). I want to change that now to a VarChar(20) 
which is plenty big enough so that I can create an index on it. But of 
course, Firebird won't let me reduce the varchar size since it is 
already populated (although no values over 20 chars long).

Any ideas?

Cheers,
Phil.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: phil.vcf
Type: text/x-vcard
Size: 250 bytes
Desc: not available
Url : http://ns3.123.co.nz/pipermail/delphi/attachments/20060508/47294ebd/phil.vcf