thanks everyone.. this one below worked best for me..

SELECT *

FROM [TSIT1].[dbo].[gl30000]

where

SUBSTRING(SUBSTRING(CAST(orcrdamt AS VARCHAR),CHARINDEX('.',CAST(orcrdamt AS VARCHAR))+1,LEN(CAST(orcrdamt AS VARCHAR))),3,1) <> '0'