trim in sql | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

trim in sql

Like using trim function in asp how do i remove spaces in sql query.
– Mahir
Have a look at LTRIM() and RTRIM() in BOL. —
Frank Kalis
Microsoft SQL Server MVP
Ich unterstütze PASS Deutschland e.V.

Thank you frankalic… I am beginer to query… I read that in sql2k we can indexed in views. How do I create index in views? thanks
It is better to start a new thread on this question. When someone only reads the topic, he wouldn’t guess that you have another question on a completely different topic. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=></a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=></a>) <br />
I beleive you don’t know about books online which is installed alongwith SQL server tools on your machine.
Refer to books online for INDEXED VIEWS and you can create index on view using CREATE INDEX statement. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
hello a mahir following link will give you a answer of your question Nilay Soni
Software Engineer.
Rishabh Software Pvt.Ltd