General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
The index could be build like (assuming that the maximum lenght for the numeric field is 10 digits):
INDEX ON PadL(Alltrim(MyNumField), 10, "0") + MyCharField1 + ...
With SET EXACT OFF, a search could be done like:
IF Seek(PadL(Alltrim(SearchValue), 10, "0"))
...
ENDIF
HTH
>I need to add some indexes to a grid so the grid will be sorted from left to right on all columns.
>The problem is that I can have one numeric field in the grid as the leftmost column. If I use STR() then the order is not right anymore. If I use PADL(ALLTRIM(...)) then I cannot search in the grid using the numeric field (I have a 'look for' option).
Previous
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