General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
TRIM commands ignored when applied to indexes?
Hi All:
If I have an index on some field and the expression I'm searching for using SEEK() has leading or trailing blanks, I don't get a match. If I try an alltrim on the search expression and the index key, I still don't get a match. I appears that TRIM commands are ignored in index expressions.
Charlie
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only