On 12-06-2021 11:13, David G. Johnston wrote:
On Saturday, June 12, 2021, Condor <condor@xxxxxxxxxx> wrote:
Hello,
Is there a way to replace select * fileds in result ?
I have select qw.* from table but I want field for example mm to be
replaced with custom value like:
select qw.*, case whem length(qw.mm) > 0 THEN
COALESCE(SUBSTRING(qw.mm,
1, 1), '') ELSE qw.mm END AS qw.mm
Is there some way to do that ?
No. If you don’t want a column from “*” to appear in the output you
cannot
use “*”. In general, for production, you should avoid “*” anyway.
David J.
Uh .. yes I know. I trying to revisit old procedures from team that left
the project ... and it's seems they use select * to a lot of places.
Thanks,
