View previous topic :: View next topic
|
Author |
Message |
balaji81_k
Active User
Joined: 29 Jun 2005 Posts: 155
|
|
|
|
Hi Rahul,
Sorry it is missing in the post , actual query has the case statement .
I break each field and even tried to cast the col2 as CHAR(2) but couldn't able to avoid the low value in the output file |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Why not cut and paste the real query - then people will be working with reality instead of something that is, basically, a figment of the imagination.
And, how do you know it is a low-value? All you have presented is a plain-text impression - not the 'hex on' view. Without that we do not know if it is a real period, a low value or some other unprintable value. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
time to lock the topic, it is going nowhere |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3049 Location: NYC,USA
|
|
|
|
I think, we should lock this topic and let the TS open a new one with right and complete query instead of piece meal. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
done |
|
Back to top |
|
|
|