On Saturday, June 12, 2021, Condor <
condor@stz-bg.com> 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.