help me Sql Question Plz Help

[Darling999]

I have two tables A and B

 

A                          B

Name                   Name

---------                 ------------

RingSouth            Ring South or Ring.South or Ring_South (One of them wuld be in the B Table field value)

                             Ringsouth_Voice

 

Now My Question is when there is a Match from Table A to Table B I mean Ringsouth = Ring South or Ring.South or Ring_South

 

I need to Update Table A with the Table B Value i.e

 

Output:

-----------------------

 

B.Name                                                                                  A.Name

----------                 Then  table A should get the update        -------------

Ring South                                                                            Ring South

 

B.Name                                                                                  A.Name

----------                 Then  table A should get the update        -------------

Ring.South                                                                            Ring.South

 

B.Name                                                                                  A.Name

----------                 Then  table A should get the update        -------------

Ring_South                                                                            Ring_South

 

Any Help on this?

[ChampakDas]

UPDATE A SET TABLEA_COLUMN = BCOLUMN
FROM TABLEA A
JOIN TABLEB B
ON BCOLUMN = A COLUMN
WHERE NEE ISTAM

 

[Darling999]

UPDATE A SET TABLEA_COLUMN = BCOLUMN
FROM TABLEA A
JOIN TABLEB B
ON BCOLUMN = A COLUMN
WHERE NEE ISTAM

 

Anthaa Direct ayitey neney raaseyseytodini kadhaa Baa...

[ChampakDas]

ite nee question naku ardam kale leda naak english sadavadam radu

Anthaa Direct ayitey neney raaseyseytodini kadhaa Baa...

 

[Darling999]

ite nee question naku ardam kale leda naak english sadavadam radu

[Darling999]

ite nee question naku ardam kale leda naak english sadavadam radu

UPDATE a
SET Name = b.Name
FROM A a
JOIN B b
ON REPLACE(REPLACE(REPLACE(b.Name,' ',''),'.',''),'_','') = a.Name

[ChampakDas]

orini banda pada 1st post lo di epudu ardam iyindi

UPDATE a
SET Name = b.Name
FROM A a
JOIN B b
ON REPLACE(REPLACE(REPLACE(b.Name,' ',''),'.',''),'_','') = a.Name

 

[ChampakDas]

aa special symbols ala replace replace replace rayakunda oka user defined function rayi to remove all special characters based on ascii so u dont have to worry in the future if there are new symbols

[Darling999]

aa special symbols ala replace replace replace rayakunda oka user defined function rayi to remove all special characters based on ascii so u dont have to worry in the future if there are new symbols

Yeah checlk cehyyali adi oka sari