Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The use of UPPER() in an index
Message
From
04/03/2008 01:37:03
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
The use of UPPER() in an index
Miscellaneous
Thread ID:
01298350
Message ID:
01298350
Views:
71
Is there a need to preserve index that used to have UPPER() in its expression, when migrating data from VFP to SQL Server? Or, simply creating an index on the field is good enough. Because, when we select the column, I haven't found a way to specific an expression on that column.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform