FUNCTIONS

i installed ssrs 2005 , have experience sql.

 

how come function not work?

 

select  substring(year_month, 1, 2) expr1
from     table1

 

i message states command not supported provider?

 

it works fine other sql tools winsql?

 

thanks

refer responses identical post in transact_sql forum.

 

often, quality of responses received related our ability ‘bounce’ ideas off of each other. in future, make easier offer assistance, , prevent folks wasting time on answered questions, please don't post multiple newsgroups. choose 1 best fits question , post there. post newsgroup if no answer in day or 2 (or if accidentally posted wrong newsgroup –and indicate you've posted elsewhere).

SQL Server  >  Getting started with SQL Server