Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 21, 2016 at 04:29 PM
    Add comment
    10|10000 characters needed characters exceeded