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.
begin:vcard
fn:Phil Middlemiss
n:Middlemiss;Phil
org:Vision Software, MTS Ltd
email;internet:[EMAIL PROTECTED]
title:Project Leader
tel;work:+64 7 3480001
tel;cell:+64 27 4592648
x-mozilla-html:TRUE
url:http://www.tumonz.co.nz
version:2.1
end:vcard

_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi

Reply via email to