How to add text string to query response? Help :-(

I'm trying to return a rescord from an oracle db surrounded(wrapped by) by 2 text strings

Example -

Select p.p_id
from person p
where p.p_name like '%smith%'

returns a list of p_id records -

1243
1236
4523
2355

But I want to put a text string before and after each record to make them links so I'd get the following repsonse -

<a href="http://www.person.com/person.asp?person=1243">Show person</a>
<a href="http://www.person.com/person.asp?person=1236">Show person</a>
<a href="http://www.person.com/person.asp?person=4523">Show person</a>
<a href="http://www.person.com/person.asp?person=2355">Show person</a>

I've been trying stuff like (admittedly MS style)

Select '<a href="http://www.person.com/person.asp?person=' + p.p_id +
'">Show person</a>'

from person p
where p.p_name like '%smith%'

but just end up with syntax errors every time.

Can anyone help?

I'm sure the answer is simple but I've been googling for an hour! Received on Thu Nov 04 2004 - 11:00:40 CST