I have 3 records grouped by ticket number(it is a field in my table), in 2 of them I have the same stdesc but in the other one I have a description that contains FREIGHT' word. If sttot field >0 and stdesc contains FREIGHT' word, I would like to get the other description else just stdesc

I am trying to add this

stdesc=max(case when(sttot >0 and stdesc like '%FREIGHT') then (stdesc = stdesc is not like '%FREIGHT') else stdesc end),

to a sql statement and sql gave me the following message

Incorrect syntax near '='.

this might work

select ticket#,
    max(case when x.stdesc is null then y.stdesc else x.stdesc end) as x.stdesc
   
                from some_table as y
left outer join(
                select ticket#,  max(stdesc) as stdesc
                from some_table
                where (sttot >0 and stdesc like '%FREIGHT')
                group by ticket#
                ) as x
on x.ticket# = y.ticket#
group by ticket#