Forum

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.

String operators are very limited in 1C:Query language.
It is recommended to add an additional field that should be recalculated when you save an object if the phone field was changed.

I see. thanks