Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rssrk
Starting Member
9 Posts |
 Posted - 2013-09-16 : 02:09:39
|
| can u help me to create a code in which it removes down vowel from it ??for example in string "chakit" the i word should be removed as it is vowel and the result should be only "chakt"thank you |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-09-16 : 03:28:14
|
In our part of the world the letter "a" is also a vowel.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
 |
|
|
rssrk
Starting Member
9 Posts |
Posted - 2013-09-16 : 03:36:36
|
| ok but where is the code |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-09-16 : 06:48:56
|
DECLARE @Sample VARHAR(100) = 'Chakit';SELECT REPLACE(REPLACE(@Sample, 'i', ''), 'o', '') AS CleanedWord
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2013-09-16 : 06:56:03
|
quote:
Originally posted by SwePeso
DECLARE @Sample VARCHAR(100) = 'Chakit';SELECT REPLACE(REPLACE(@Sample, 'i', ''), 'a', '') AS CleanedWord
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Too old to Rock'n'Roll too young to die. |
|
|
|
|
|
|
|
|
vowel eater
read here for your problem: