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 |
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2007-02-15 : 11:40:40
|
| Hello,Why is it giving me this error?Msg 102, Level 15, State 1, Line 20Incorrect syntax near ')'.on this line of code??where substring (compl_cde_ojb, 1, 3) = CODE (+)Thanks,Kurt |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-15 : 12:09:50
|
| What is "CODE(+)" supposed to do?Kristen |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-15 : 12:28:18
|
| There are a lot of good books for ORACLE programmers who wants to go T-SQL instead.Peter LarssonHelsingborg, Sweden |
 |
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2007-02-15 : 12:53:57
|
| Hello Kirsten,You were exactly correct. I removed the (+) and that fixed it.Thanks,Kurt |
 |
|
|
|
|
|