You are responsible for managing a SQL Server 2005 database that stores sales information.
Many values in nchar columns in the database tables contain preceding or trailing spaces.
You need to implement a mechanism that selects the data from the tables without leading and trailing spaces.
Your solution must be available for reuse in Transact-SQL statements and views.
What should you do?
A.
Create DML triggers that query the inserted and deleted tables.
B.
Create a stored procedure that calls the LTRIM and RTRIM built-in functions.
C.
Create a Transact-SQL function that calls the LTRIM and RTRIM built-in functions.
D.
Call the TRIM built-in function.