convert number to text

[grabrail]

Hi

sorry for the simple question, but this escapes me.

I have a simple select query that gets me 3 pieces of information from a database.

servername, taskname and status

now, status is a number from 1 to 5, each number as a particular meaning, ie 3 = not running.

What I want my query to display is "not running" instead of 3.

How do I achieve this.

Cheers

 

[ca8msm]

You can use the CASE function


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[grabrail]

Great thanks, I have acheived what I need with this.

Thanks again

 

[bborissov]

Just a thought, Why not use some internal table where you could keep Status texts. It would be easier if after a while you add some additional status messages.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP