sql - DB2- How to check if varchar field value has integers

Question

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Is there an inbuilt DB2 function or any query to check if the character i have is a number? (I cannot use user defined functions)

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

389 views

1 Answer

深蓝 · Answer 1 · 2021-10-23T17:53:39+0000

answered Oct 24, 2021 by 深蓝 (71.8m points)

CASE
  WHEN LENGTH(RTRIM(TRANSLATE(test_str, '*', ' 0123456789'))) = 0 
  THEN 'All digits'
  ELSE 'No'
END

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…