<div>
I think you mean if it start with &quot;V1&quot; you want to change the prefix to &quot;PN&quot;.<br />
<br />
You're in luck; this is an easy one.<br />
<br />
UPDATE YourTable<br />
&nbsp; &nbsp; &nbsp; SET YourColumn = STUFF(YourColumn,1,2,'PN')<wbr /><br />
&nbsp;WHERE YourColumn LIKE 'V1%'<br />
<br />
The % wild card matches any number of characters including 0. &nbsp;If you want to specifically change just the rows with 5 characters after the V1, change it to.....<br />
<br />
&nbsp; LIKE 'V1_____'<br />
<br />
using 5 underscores which are the single character wild card.<br />
<br />
Regards,<br />
Bill
</div>


I think you mean if it start with "V1" you want to change the prefix to "PN".

You're in luck; this is an easy one.

UPDATE YourTable
      SET YourColumn = STUFF(YourColumn,1,2,'PN')
 WHERE YourColumn LIKE 'V1%'

The % wild card matches any number of characters including 0.  If you want to specifically change just the rows with 5 characters after the V1, change it to.....

  LIKE 'V1_____'

using 5 underscores which are the single character wild card.

Regards,
Bill

<div>
is this a sybase function STUFF???<br />
<br />
what does this do?<br />
<br />

</div>


is this a sybase function STUFF???

what does this do?



<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
would appreciate help with a sql<br />
<br />
I need to write a sybase sql which does the following,<br />
<br />
It should look for a value in the column and if it starts with V1XXXXX -- it should change to PNXXXXX<br />
Can you kindly help me with this,<br />
<br />
Thanks,
</div>
</div>


Hi experts,

would appreciate help with a sql

I need to write a sybase sql which does the following,

It should look for a value in the column and if it starts with V1XXXXX -- it should change to PNXXXXX
Can you kindly help me with this,

Thanks,

a sybase sql help please

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.