i was using ms access as my database where my default value for coloum was "" empty string . now i have shifted to sql 2008 where i cannot put empty sting as default value in the same manner as in access i.e "" . here i have to put either '' or " " ie with space within quotes. this value is treated different from "" value. for eg in statement like
if flexgrid.TextMatrix(1, 1)="" then
How can i set empty string in sql so that value is same as access.