Skip to content

Instantly share code, notes, and snippets.

@kovid-r

kovid-r/cast_ex_special_case_example.sql

Last active May 19, 2020 12:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kovid-r/f9c8ea1adb4c775bb16b423881d03202 to your computer and use it in GitHub Desktop.
Save kovid-r/f9c8ea1adb4c775bb16b423881d03202 to your computer and use it in GitHub Desktop.
Download ZIP
Special Case Example for Casting
Raw
cast_ex_special_case_example.sql
select a, b, a = b
from (
select 13 a, '13dfgs' b union all
select 13 a, '130dfgs' b union all
select 13 a, '13' b union all
select 13 a, '0013dfgs' b union all
select 13 a, ' 13dfgs' b union all
select 13 a, 'dfgs13'
) as t;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment