Skip to Content
0

Crystal: How to Change a part of a string in SQL Server using REPLACE or any other function

Dec 21, 2016 at 04:06 PM

19

avatar image

hi,

I would like to update the following Myfield from MyTable before using it in crystal reports:

===================

Myfield

123456789

646787947

654766897

568799780

===================

I would like to replace by 3 stars any characters in the middle of ma values. Knowing that numbers can be anything but fixed.

This means I would like to update my table to get the following result:

===================

Myfield

123***789

646***947

654***897

568***780

===================

Is there any query to do so?

Thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vitaly Izmaylov
Dec 21, 2016 at 04:29 PM
0
Share
10 |10000 characters needed characters left characters exceeded