Link to home
Start Free TrialLog in
Avatar of bibi92
bibi92Flag for France

asked on

replace \ by - in select

Hello,

How can I modify this sql statement to replace \ by - on select statement :
set nocount on; SELECT DISTINCT REPLACE(REPLACE(REPLACE(name,'[',''),']',''),' ', '') FROM msdb..sysjobs

Thanks

regards
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bibi92

ASKER

solved but Rgonzo1971 has answered
Avatar of bibi92

ASKER

thanks regards