MySQL server reporting services


#1

Hi,
I have data as below:

Abcdef234667
23789
A34678
A2cede23789
A23456

I need a sql query to replace the text with blank and challenge here is some case we see data as “A3ghd23467”, here I have to replace even number too existing between letters along with those letters to blank.

Please help me out and thanks in advance


#2

@Rdharmegowda

If I understand it right, you need to replace all the text with blank? What is the expected outcome for Row 2 here - 23789?

Kunal