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

Sparky wrote:

> 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!

Go to http://www.psoug.org
click on Morgan's Library
click on String Functions
Scroll down to CONCAT and Vertical Bars

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)