Converting Val function in access to SQL Server

[Morore_Charles_007]

Hi i have this function Val(Right([ContractNo],6) and its in Access format how do i change it to SQL Server Thanx

[GuyThiebaut]

try

substring(ContractNo,len(ContractNo)-5,6)

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

[Simon_Whale]

As Val only returns numbers until the first non number is found, there is no out of the box solution I would have a read of this Get only the number from a string, T-SQL???[^]

Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON

[Maciej Los]

Why? What kind of data are there?

[Morore_Charles_007]

Thank you it works

[GuyThiebaut]

Great, don't forget to upvote posts that help you ;)

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens