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
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

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=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

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
Moderator
http://www.SQL-Server-Performance.Com/forum
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 http://forums.databasejournal.com/history/topic.php/9731-1.html Nilay Soni
Software Engineer.
Rishabh Software Pvt.Ltd

]]>