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 |
|
fonzie
Starting Member
31 Posts |
 Posted - 2005-11-23 : 10:09:07
|
| I am getting Invalid column name 'substr(NOUN,1,17)'in my select statement? Am I not allowed to select a partial string?SelectCommand="SELECT [OFFICE], [substr(NOUN,1,17)] from ......" |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-11-23 : 10:13:08
|
| the sub string function is substring-----------------[KH] |
 |
|
|
fonzie
Starting Member
31 Posts |
Posted - 2005-11-23 : 12:35:56
|
| I tried that too: Invalid column name 'substring(NOUN,1,17)'. server is SQLserver |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-24 : 00:29:59
|
>>[substr(NOUN,1,17)] As you used squre braces, it is treated as a column so as the error  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
Why am I getting Invalid column name ?