i have this code in where clause RTRIM(LTRIM(ODER_ID))= ' ',WHAT THis do
It filters out rows with non-blank oder_id values. RTRIM and LTRIM simply remove spaces from a string on the right and left.
As an example;
with SampleTable as (
select ' hi ' as oder_id, 1 as Col2 union all
select ' ', 2 union all
select '', 3
)
select * from SampleTable where rtrim(ltrim(oder_id))=''
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.