-
Recent Posts
Categories
Meta
Tag Archives: string manipulation
Remove Characters in String T-SQL with No Loop Part 2
Okay, expanding on what I did yesterday. I Built a table, called ExclusionList with one field, ExcludedText E.g. Then created a function: You can then use like this:
Remove Characters in String T-SQL with No Loop
Ok, I’ve seen many ways to do this using loops, but nothing in plain T-SQL Let’s say we have a string that may contain illegal characters, in my case it was project identifiers that needed to be used as file … Continue reading
Posted in Programming
Tagged Character Replacement, REPLACE, sql, sql server, string manipulation, t-sql, without loop
Leave a comment
Reverse a string in C#
Lots of people seem to want to do this… one neat way is to utilise Array.Reverse Pass the string to a char array, use Array.Reverse then pass the char array back as a string.