Ignore Text in Column
Posted on 2007-08-01
I have the query below - How do i ignore any entries in the column where they are TEXT entries.
E.g in the column acc.account - it can have entries such as:
I want the query to ignore any records which are not numeric. Any ideas?
--CAST (acc.Account AS INT),
BM10MACELV.dbo.Projects proj LEFT JOIN SQSDBA.v_Account acc ON proj.[project nr] = RIGHT(acc.ACCOUNT,5)
Where acc.Ledger = 'P_INTPROJECT'