Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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..

Not what you were looking for? View more on this topic or Ask a question