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 |
|
acesover
Starting Member
15 Posts |
 Posted - 2010-04-21 : 12:06:24
|
| I would like to create an index using expressions like SUBSTRING to build the key. I thought this was possible, but I can't seem to get SQL Server to parse my Create Index statement. I suppose I could create a view, and index from that, but was just wondering if the expression-based index can actually be created. Thanks.Dan |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Can you create indexes based on expressions?