Replace New Value with Existence old values in Columns

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

SQL

select convert(varchar,tournamentID='STT') from tblTournaments

whatever is TournamentID column values, in it i want to replace them with 'STT' name...!
please do right my queary...!

Note:- don't want to use REPLACE Keyword..! want to add only run time values.
if i write
select tournamentID='STT' from tblTournaments
its run but upper queary not working!
i want to like this output..!

VB

TournamentID
STT
STT
STT
STT
STT
STT

Regards
Dnyanesh Wahiley

Posted 22-Feb-12 18:32pm

Dnyanesh Wahiley

Updated 22-Feb-12 18:46pm

v3

Add a Solution

Comments

CRDave1988 23-Feb-12 0:37am

Not Getting what is ur problem can u explain more or can u provide a sample output?

Dnyanesh Wahiley 23-Feb-12 0:41am

see for example if i write select tounamentID from tablename its shows me '1' as a an output..! now what i want insted of '1' i want 'STT'

Om Prakash Pant 23-Feb-12 0:49am

then in that case you only need this
select 'STT' from tblTournaments

Dnyanesh Wahiley 23-Feb-12 0:52am

and what about column name..!

Om Prakash Pant 23-Feb-12 1:12am

select 'STT' as tournamentID from tblTournaments

Dnyanesh Wahiley 23-Feb-12 1:16am

Exactly..! Thanks Bro its works..! Thaks a lot

Varun Sareen 23-Feb-12 1:18am

query by om prakash pant will work for your problem

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dnyanesh Wahiley · Accepted Answer · 2012-02-22T19:17:00

Solution 1

select 'STT' as 'TounamentID' from tblTournaments
this will be queary...!

Posted 22-Feb-12 19:17pm

Dnyanesh Wahiley