Hi all. When I'm talking to MySQL, I can easily get the default for a column from the COLUMN_DEF key from column_info. However when I'm talking to SQL Server, it doesn't return an actual value, but a 'create default' statement such as:
CREATE DEFAULT dbo.Contacts_Salutations_D AS 'Mr' Is there anything available that will parse this for me and return the actual value? I realise I can just grab the stuff in quotes, but I'm just checking if there is a better way. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au