<div>
Where acc.Ledger = 'P_INTPROJECT' &nbsp;AND ISNUMERIC(acc.Account) = 1<br />

</div>


Where acc.Ledger = 'P_INTPROJECT'  AND ISNUMERIC(acc.Account) = 1


<div>
SELECT blah blah blah<br />
FROM blah<br />
WHERE ISNUMERIC(acc.ACCOUNT)
</div>


SELECT blah blah blah
FROM blah
WHERE ISNUMERIC(acc.ACCOUNT)

<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
I have the query below - How do i ignore any entries in the column where they are TEXT entries.<br />
<br />
E.g in the column acc.account - it can have entries such as:<br />
12345<br />
test<br />
345<br />
qwe<br />
<br />
I want the query to ignore any records which are not numeric. Any ideas?<br />
<br />
Select &nbsp;<br />
--CAST (acc.Account AS INT), <br />
acc.TITLE, <br />
RIGHT(acc.ACCOUNT,5)<br />
From <br />
BM10MACELV.dbo.Projects proj LEFT JOIN SQSDBA.v_Account acc ON proj.[project nr] = &nbsp;RIGHT(acc.ACCOUNT,5)<br />
Where acc.Ledger = 'P_INTPROJECT' <br />
<br />
<br />
Thanks again
</div>
</div>


Hi 

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:
12345
test
345
qwe

I want the query to ignore any records which are not numeric. Any ideas?

Select  
--CAST (acc.Account AS INT), 
acc.TITLE, 
RIGHT(acc.ACCOUNT,5)
From 
BM10MACELV.dbo.Projects proj LEFT JOIN SQSDBA.v_Account acc ON proj.[project nr] =  RIGHT(acc.ACCOUNT,5)
Where acc.Ledger = 'P_INTPROJECT' 


Thanks again

Ignore Text in Column

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.