I have string with number, how to get number out of this string in sql server

I have string something like ACGI SHIPPING (3471) and i need to get 3471 number out of it.

If there is no number just print 0. in sqlserver