how to trim values of xml attribute?

Rajesh Kumar Yadav 1

Hi,

I want to trim @cotd

so is there any function which can do it.


		 SELECT LTRIM(RTRIM(R.C.value('@Name','nvarchar(100)'))) 
		        
		 FROM @xm.nodes('/test[ fn:lower-case(@cotd) !=""]') AS R(C)

Wilko van de Velde 2,226 Reputation points

2023-11-10T10:27:15.78+00:00

Can you provide the value of @xm?
Yitzhak Khabinsky 26,201 Reputation points

2023-11-10T16:56:32.84+00:00

While asking a question you need to provide a minimal reproducible example:

(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.

(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.

(3) Desired output based on the sample data in the #1 above.

(4) Your SQL Server version (SELECT @@version;)
PercyTang-MSFT 12,501 Reputation points Microsoft Vendor

2023-11-14T02:17:34.99+00:00

Hi @Rajesh Kumar Yadav

You need to provide more information based on the experts' comments.

1 answer