SQL sentence and SBO
Hi gurus !!
i have a probleme whith a simple (i think...) query :
I create a USerTable and i populate "Code" and "Name" with the value which are the max + 1.
All is ok until 10...
So, i convert my "Code" field :
SELECT MAX(CONVERT(NUMERIC(8),Code)) as TEST FROM dbo.[@USERT_TABLE]
On Sql Server, i don't have any problem, via SBO, :
"Convert of then string "" in a double isn't valid !!"
Why ? There is no row whith "" in Code (fortunatly, it's the primary key...)
Thanks for your help and time.
PS : Sorry for my english..