How do you rename a column (or should that be field) using a SQL statement? I've started playing around with ALTER TABLE and CONSTRAINTS, but can't find the syntax for this. Thanks in advance. BTW, *completely* off topic, but does ICQ 2000b have Active Lists? I was on 2 CF Active Lists but there's no AL button on the latest version. -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ------------------------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]

