vbnetcoder
asked on
Query - show only records where a field has a numeric value AND the value is > 6
I have a field that can contain number or letters.
I want to return records if the field contains a number AND the number is > 6
What would be the syntax?
I want to return records if the field contains a number AND the number is > 6
What would be the syntax?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ty
where isnumeric(yourfield) != 0
and yourfield > 6