I have a file qvw your database a xml file. I need to modify some data in some fields, eg the field MANAGER presents the data as follows: 132; # Name Manager. I need to be displayed only the name follows: name manager (without previous code). Thank you all for your help.
SubField(MANAGER,'# ',2) AS MANAGER,
Hope this helps,
I used some functions character and was as follows:
Mid(ows_Field, NumSum(Index(ows_Field, '#', 1), 1)) as 'Field',
Thank's Jason for help.
Retrieving data ...