<div>
<div class="content wysiwyg-content">
Hi, 
 
I want to update a table use a pattern for example: 
 
update products set productid = &quot;productid/productid&quot; where productid = &nbsp;&quot;productid-productid 
 
Is that possible? 
 
From example: 
id, productid,price 
1, 100-1,1 
2,200-1,1 
 
To example: 
id, productid,price 
1, 100/1,1 
2,200/1,1 
 
 
Thanks 

</div>
</div>

Hi,

I want to update a table use a pattern for example:

update products set productid = "productid/productid" where productid =  "productid-productid

Is that possible?

From example:
id, productid,price
1, 100-1,1
2,200-1,1

To example:
id, productid,price
1, 100/1,1
2,200/1,1


Thanks


Sybase SQL update column with pattern

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Sybase Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.