Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
Hi Mike
EMPTY() is not Rushmore Optimizable.
I'd go one further than Jim...
lcBlank = space(len(posted))
REPLACE Posted with "JUL02" FOR Posted = m.lcBlank
>Hi Jim,
>
>What is the SPACE(LEN()) about? I would expect performance to be fine just indexing on Posted and running the REPLACE command the way Randy already has it.
>
>Mike
Previous
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