Perhaps you could try "UCASE(capital) as capital" ... Dave Copeland.
On 12/11/2013 01:16 PM, Eric Kom wrote: > Hi all, > > Please I got small issue with lazarus on how to pass SQL statement > with a function as above: > > SELECT city, UCASE(capital) FROM country; > > the capital column doesn't show on the DBGrid > > Thanks > -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
