Answer 1

I found this, you didn't mention the DBMS, so, this is the first on Google search results from query " reverse string without sql reverse". You can track the rest of the search results by using that query. Is this asked on your interview?

https://sqlwithmanoj.com/2011/08/18/reverse-a-string-without-using-tsqls-reverse-function