By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
COLUMN_NAME | VALUE | IS_NUMBER |
---|---|---|
Test1 | 80933Y355220 | N |
Test1 | 8093363X5220 | N |
Test1 | 809336355220 | Y |
Test1 | 80.98 | Y |
Test1 | -80.98 | Y |
Test2 | 1234 | Y |
Test2 | abc | N |
Test2 | 12-23-09 | N |
COLUMN_NAME | VALUE | IS_NUMBER |
---|---|---|
Test1 | 80933Y355220 | 0 |
Test1 | 8093363X5220 | 0 |
Test1 | 809336355220 | 1 |
Test1 | 80.98 | 1 |
Test1 | -80.98 | 1 |
Test2 | 1234 | 1 |
Test2 | abc | 0 |
Test2 | 12-23-09 | 0 |