Convert the Sql Query result to lowercase

[swap123]

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!!!

 

[Hack]

What will you do with it once you get it out?

Perhaps there is a way to lowercase it when you actually use it.

 

[Tom]

I think it would be better to write out each of the fields you are querying in your select statement. Using Select * winds up being used all to often and returning extra fields of data that may not even be needed. I think it is more efficient to only call the actual needed fields. Also moving the query to a stored procedure will give a bit extra flexibility of adding/editing the called fields if needed in the future.