simple query to find records which are not numbers

[rehanemis]

Hi Professionals,

I have an table that contains StudentID, Name and Age. I have imported the data from Excel sheet and there are some records which contains Null Value and some "h", "n/a" etc. I would like to design query which finds the records that are non numeric.

Thanks and waiting of your answer.

 

[pbaldy]

Try

SELECT...
FROM...
WHERE Not IsNumeric(FieldName)

 

[gemma-the-husky]

or just change the data type to a number, and the non-numbers will be dropped, I think. Then you can fill in the blanks.