Forum

Hi all,
I try to trim value in sql that the same in sql server but I could not do it
Please help me!

Hello, Dinh Hung!

Please provide steps that you are performing, source and resulting values.

Plus if you are trying to manage data of the application directly in the SQL database, you might break the data consistency. It is recommended to use 1C:Enterprise platform features only to handle the data.

Dear Admin!
This is my sql statement

 "SELECT
|Emp.Code,
|Emp.Description
|FROM
|Catalog.Employees AS Emp"

"SELECT
|Trim(Emp.Code),
|Trim(Emp.Description)
|FROM
|Catalog.Employees AS Emp"

Hello, Dinh Hung!

It is better to keep this data trimmed than trying to process it using SQL. So I recommend you to process entire the data and change Code and Description to trimmed ones.
In more complicated cases it is better to add an additional attribute that will keep precalcualted values, updated when an item is written.

Of course remember to make a backup before doing this.

Hi Timofey!
Thanks for your support but I think it's not a best solution.