And another variation is
SELECT ...
FROM YourTable
WHERE 1 = ISNUMERIC( SUBSTRING( FieldName, 1, 1))
However, If you need to find this kind of information in your query it may indicate that you are actually concatenating two separate data items inside a single field. So if that would be the case, then I'd suggest that you store each data in it's own field.