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):

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

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

multithreading - Exception in Application constructor -

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -