Getting result

select

WWMLNM,* from crpdta.F0111 a

left

outer join crpdta.f0101 on wwan8=aban8

where

WWIDLN=0 and ABTAXC in('N' , 'P','1' )

and

wwan8 in(select a6an8 from crpdta.f0401)

and

WWMLNM like '%,%' and upper(WWMLNM) =WWMLNM COLLATE Latin1_General_BIN

Convert datetime with 00 time - sql-server

select cast(convert(char(11), getdate(), 113) as datetime)