Page 1 of 1
Converting the char 4 bytes to numeric
Posted: Mon Jun 16, 2008 9:38 am
by nsubbarao
Hi All,
I have a database field EFFECTIVE_DATE - Char 4 bytes and it has a value 9607 and my requirement goes like this.
I have to compare this EFFECTIVE_DATE against a value to check whether it is greater than 9607. I need to convert the EFFECTIVE_DATE to numeric and compare it against 9607. Could anyone please help me.
Posted: Mon Jun 16, 2008 9:50 am
by chulett
Just do the comparison. Server isn't picky about data types so no 'conversion' is necessary.
Hi chulett
Posted: Mon Jun 16, 2008 9:57 am
by nsubbarao
chulett wrote:Just do the comparison. Server isn't picky about data types so no 'conversion' is necessary. ...
I tried it but it is not giving me the desired output.
STW_EFFECTIVE_DATE - 9607
The condition goes like this :
If STW_EFFECTIVE_DATE > 9606
Then (STW_NEW_STAT_AREA2[1,48] : "1" : STW_NEW_STAT_AREA2[50,50])
Else STW_NEW_STAT_AREA2
When I give this condition I am not able to see the STW_NEW_STAT_AREA2 field populated with the desired value which is '1'
Posted: Mon Jun 16, 2008 10:01 am
by chulett
Not a conversion thing, I'd wager. What's in your AREA2 field? If either of those substrings return a null, all you'll end up with is a null after concatenation.
Posted: Mon Jun 16, 2008 10:05 am
by nsubbarao
chulett wrote:Not a conversion thing, I'd wager. What's in your AREA2 field? If either of those substrings return a null, all you'll end up with is a null after concatenation. ...
STW_EFFECTIVE_DATE = 9607
STW_NEW_STAT_AREA2 = 92 5 40119500725114 012003031196607 19150000 9 0 000000002 0050
These are the input column values.
My desired output should be
STW_NEW_STAT_AREA2 = 92 5 40119500725114 012003031196607 19150000 9 0
1000000002 0050
Posted: Mon Jun 16, 2008 10:13 am
by chulett
Hmmm... ok. What if you quote the comparison?
Code: Select all
If STW_EFFECTIVE_DATE > "9606" Then
Posted: Mon Jun 16, 2008 10:14 am
by nsubbarao
chulett wrote:Hmmm... ok. What if you quote the comparison?
Code: Select all
If STW_EFFECTIVE_DATE > "9606" Then
...
Let me try !!!
Posted: Mon Jun 16, 2008 10:16 am
by nsubbarao
nsubbarao wrote:chulett wrote:Hmmm... ok. What if you quote the comparison?
Code: Select all
If STW_EFFECTIVE_DATE > "9606" Then
...
Let me try !!!
Still no luck chulette.