Trim function in a view 2

[levinll]

Is it possible to have the Trim function in a view ? I'd like to remove all leading and trailing spaces in a field prior to it being transferred. I can't use a stored procedure because I'm having the data read directly into an Excel Template using Microsoft Query.

Thanks !

 

[MeanGreen]

Yes. Just in your view definition use the Ltrim and Rtrim for each column you want trimmed.

Hope this helps.

 

[osjohnm]

Hi

Yes you can but you have to use "AS" otherwise sql server will complain about missing column names.

eg:

create view books
as
select book_id, ltrim(rtrim(book_name)) AS book_name, author
from books

Hope this helps

John