General Tech Bugs & Fixes 2 years ago
Posted on 16 Aug 2022, this text provides information on Bugs & Fixes related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.
Please try this.
DECLARE @Numstring varchar(100)
SET @Numstring = 'AB12C34DE'
WHILE PATINDEX('%[^0-9]%',@Numstring) <> 0.
SET @Numstring = STUFF(@Numstring,PATINDEX('%[^0-9]%',@Numstring),1,'')
SELECT @Numstring As Number
DECLARE @Charstring varchar(100)
SET @Charstring = 'AB12C34DE'
WHILE PATINDEX('%[^A-Z]%',@Charstring) <> 0.
SET @Charstring = STUFF(@Charstring,PATINDEX('%[^A-Z]%',@Charstring),1,'')
SELECT @Charstring As CharacterNo matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
General Tech 10 Answers
General Tech 7 Answers
General Tech 3 Answers
General Tech 9 Answers
manpreet![Tuteehub forum best answer]()
Best Answer
2 years ago
How Can I separate characters and number from a word using SQL Server query?
Example word:
AB12C34DEThe Output is like: