updating a string or a word from a column from SQL Server

Question

0.00/5 (No votes)

See more:

Hi,

i have a table called testtb

In testtb table, id and desc are two the columns.

id desc

1 val(5679) from cdetail

2 val(idsk) from exide

Now i want to replace the val(5679) with cast(5679 as int) progmatically using SQL. same thing for the next row until it finds val().

Please let me know some suggetsions

Posted 14-Mar-13 19:42pm

PRAKASH_N

Add a Solution

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)

gvprabu · Answer 1 · 2013-03-14T20:00:00

Solution 1

Hi,

Try This....

SQL

DECLARE @Test TABLE(id int, [desc] varchar(1000))
DECLARE @ReplaceStr VARCHAR(30)='cast(5679 as int)'

INSERT INTO @Test(id,[desc])
VALUES(1, ' val(5679) from cdetail'),(2, ' val(idsk) from exide ')

SELECT id, [desc], 
    REPLACE([desc],(SUBSTRING([desc],CHARINDEX('val(',[desc],1),(CHARINDEX(')',[desc],1)-CHARINDEX('val(',[desc],1))+1)),@ReplaceStr) 'RequiredDesc'
FROM @test

-- Note : If only one val() then only it will work :-)
Regards,
GVPrabu

Posted 14-Mar-13 20:00pm

gvprabu

Updated 14-Mar-13 20:09pm

v3

Comments

PRAKASH_N 15-Mar-13 2:10am

it has more than 10 val().....

gvprabu 15-Mar-13 2:11am

all val() in same row ?

gvprabu 15-Mar-13 2:13am

If all the val() in same row, then go for Loop, same logic you can use.... up to all val() replaced ... :-)

PRAKASH_N 15-Mar-13 2:28am

val() in same row and in next rows also......

gvprabu 15-Mar-13 3:14am

Ok, then go for loop. how many rows are there?

CHill60 18-Mar-13 10:59am

My downvote for hard-coding the DECLARE @ReplaceStr VARCHAR(30)='cast(5679 as int)'

gvprabu 19-Mar-13 0:08am

Read the Question, He want to replace all "val()" Function to "cast()" Function. For example
"val(5679)" -> "cast(5679 as int)". So without hard code the values how we will get the "cast()" Function String?.