sql server - How Select Distinct Not convertable Value on a Column at SQL Sever -
i have table, 1 of field string, value may int (convertable int) , maybe string (column update by):
if value system service, means not related user table if value convertable int, means related user table.
how can select distinct value not related user table?
*update string on db.
if integer looking for, not like better isnumeric():
select distinct [update by] t [update by] not '%[^0-9]%'; 
Comments
Post a Comment