The Select Statement and the Reverse Function in SQL

Friday, March 14, 2008

I found out today something quite peculiar, which I didn't know up till now. I have a table which has codes and names in it. The names are in Hebrew and need to be reversed. The table should have rows in it only if there exists a description for the code. It shouldn't have codes in it that don't have a description. This is my select statement and its result:   Which was weird, because why would I have a blank line for a code? I shouldn't have a line for it at all in that case. Still, I needed to reverse...
one comment