Hi,
I have a sql Query
select * from Table where tradedate = "date";
I want to get all the result in lowercase
I know I can use the lower() function but for that I may have to write
select lower(id), lower(desc),lower(position) from Table where tradedate = "date";
Is there any way to incorporate this 'lower' function with "select *"? or is there any other way to do that??
Thanks!!!
I have a sql Query
select * from Table where tradedate = "date";
I want to get all the result in lowercase
I know I can use the lower() function but for that I may have to write
select lower(id), lower(desc),lower(position) from Table where tradedate = "date";
Is there any way to incorporate this 'lower' function with "select *"? or is there any other way to do that??
Thanks!!!