>>can you expound on that method a bit?im more familiar with using Replace and SQL to populate my tables
>
>A cursor is a table which is stored in memory, and is typically used to store temporary data. Since you "Select into table Greater", I wonder whether Greater is a table used for permanent storage of data, or only temporary date?
>
>NB! If you hover the mouse over Message view setup in the upper right corner of this textbox, and select Enable auto quote, it's easier to answer your questions since the whole or parts of the earlier messages will be carried over to your reply.


if i use a temp table...i wont be able to index it will i?