Hi is there way to use StrReplace, Left, Right methods in Query?
I have records (type string) as:
+90 (534) 079 34 01
(534) 079-34-01
(534) 079-3401
5340793401
0534 079 34 01
+905340793401
So after executing query it's yet to get "5340793401".
I should use it in query caurse the number of records are very much (It will took more seconds if I will iterate the query results and convert those records by using usual mothods in script). So I need to use those methods in query.
Common questions about 1C:Query language, Query builder tool and Data composition schema