SELECT 
CASE 
WHEN NUMBER LIKE '%W%' THEN 'W' 
ELSE NULL 
END AS ch,
REPLACE(NUMBER, 'W', '') AS number,
LENGTH(REPLACE(NUMBER, 'W', '')) AS len,
LENGTH(NUMBER) AS length
FROM 
skaititaji