Re: Replace String Function

[John Mistler]

Thanks for the reply. I am not sure how UPDATE would help me in this situation. I should be more clear:

The goal is to issue a SELECT statement to return 'apple' instead of 'a', 'baseball' instead of 'b', and 'cookie' instead of 'c'; not to update entries already in the table. I am saving space on my hard drive by storing only single letters in the column, rather than full strings. But I want the query to return full strings instead of single letters. Does this make more sense?

Thanks,

John