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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Syntax error

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 20
Incorrect 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
Go to Top of Page

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 Larsson
Helsingborg, Sweden
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -