Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2003-10-21 : 11:36:17
|
hello all,is it possible to run functions such as RTRIM when using OPENQUERY ?such as :SELECT *FROM OPENQUERY(LINKEDSERVER, 'SELECT RTRIM(FULLNAME)FROM ADDRESS ')thanks for any help !Jamie |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2003-10-21 : 11:55:05
|
Just worked this one out !without an AS it won't work, so need to do :SELECT RTRIM(Fullname) AS FullNAMEthanks anyway ! |
 |
|
|
|
|
|
run functions through OPENQUERY