Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dataman
Starting Member
1 Post |
 Posted - 2007-08-27 : 13:12:22
|
| I have a table: batch_date numeric (8,0) batch_nmbr numeric (5,0) batch_ctr numeric (4,0) col4... col5... col6...I am trying to select data using something like:select col1, col2 FROM tablename WHERE (BATCH_DATE + BATCH_NMBR + BATCH_CTR) >= (:BATCH-DATE + :BATCH-NMBR + :BATCH-CTR) this is a mssql cursor embedded in a microfocus cobol program. I do not get predictable results. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-27 : 13:15:00
|
| (1) It doesnt look like t-SQL.(2) You need to convert numeric values to string/varchar before concatenation.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
numeric concatenation failure on 4 fields