SELECT statement

[nerd19]

I have a table with a bunch of districts where the fieldname is DistCode. I have a select statement as follows: SELECT distcode = 'sta' from tableDistCode
What i want to do is replace 'sta' in the results with 'state', how can i do this. Thanks

 

[RiverGuy]

SELECT REPLACE(distcode, 'sta', 'state')

 

[nerd19]

I have tried that but i recieve that 'no column was specified for column 1 of DistCode'

 

[nerd19]

got it, had to do a distcode = replace....

Thanks tho

 

[bborissov]

SELECT REPLACE(distcode, 'sta', 'state') 
FROM YourTable

But I'll do this:

SELECT CASE WHEN distcode = 'state'
            THEN distcode
       ELSE REPLACE(distcode, 'sta', 'state') END AS DistCode
FROM YourTable

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.