Subject | constants interpreted as char instead of varchar |
---|---|
Author | woodsmailbox |
Post date | 2009-03-03T18:36:20Z |
is there any shortcut to make 'x' a varchar instead of char in sql
expressions? for instance,
decode(1 = 1, 'a', 'ab')||'c'
returns 'a c' instead of the more intuitive 'ac'... casting all
constants to varchar makes expressions unreadable. if beating up a
dead horse, then sorry for the noise.
expressions? for instance,
decode(1 = 1, 'a', 'ab')||'c'
returns 'a c' instead of the more intuitive 'ac'... casting all
constants to varchar makes expressions unreadable. if beating up a
dead horse, then sorry for the noise.