need help on this SQL problem. Thank you!

Write ONE SQL statement which uses the SUBSTR function (as many times as you need to) to extract the following three words: ‘I’, ‘am’, ‘here’ from the string

‘Where am I?’ and put the three words together using a combination of the CONCAT function and the ||. 

 

E.g. The starting string used in the SQL statement is:  ‘Where am I?’

 

       The output of the SQL statement after we run it will be:

 

TRANS

----------

I am here

所有跟帖： 

• Answer form one of my students -美國老土- ♂ (188 bytes) () 11/14/2012 postreply 15:54:31

• 回複：Answer form one of my students -多布施川- ♀ (191 bytes) () 11/14/2012 postreply 17:59:20