valid_name( character_expression )
Returns 0 if the character expression is not a valid identifier, or a number other than 0 if it is a valid identifier.
Example
select 'SIP_upd_Feature' = Valid_name('SIP_upd_Feature')
, '@Parameter' = Valid_name('@Parameter')