Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About
SQL

How to hide letters with asterisks except first letter in SQL

- 08.11.21 - ErcanOPAK

The easiest way to do that is using a function

CREATE FUNCTION [dbo].[HideNameWithAsterisks](@Name varchar(max))

RETURNS varchar(MAX)

AS

BEGIN

    DECLARE @loop int = LEN(@Name)

    WHILE @loop > 1

    SELECT @Name = STUFF(@Name, @loop, 1,
    CASE WHEN SUBSTRING(@Name, @loop - 1, 2) like '% ' THEN ' '
     WHEN SUBSTRING(@Name, @loop - 1, 2) like ' %' then substring(@Name, @loop, 1)
     ELSE '*' END), @loop += -1

    return @Name;

END

and here is the usage

SELECT dbo.HideNameWithAsterisks(N'The KinGS Never DIE!')

Output: T** K**** N**** D***

 

Related posts:

Unique Constraints in MS SQL Server to prevent duplications
Get the First and Last Word from a String or Sentence in SQL
How to find records based on CAPITAL and small letters in SQL Query?
Database stuck in “Restoring” state
Search text in all tables in SQL Server
Post Views: 0

Post navigation

How replace characters with asterisks (*) except first characters
Change button size full-width in Bootstrap

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

May 2022
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Apr    

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (333)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (223)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (191)
  • Find numbers with more than two decimal places in SQL (191)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (190)
  • Confirm before process with ASPxButton in Devexpress (189)
  • How to make some specific word(s) Bold or Underline in ReportViewer (189)
  • Devexpress ASPxGridview Column Grouping in Code (177)
  • Add Constraint to SQL Table to ensure email contains @ (174)
  • Tense Changes When Using Reported Speech (168)

Recent Posts

  • How to make the default class type ‘public’ instead of ‘internal’ in Visual Studio
  • How to put text inside MVC Razor code block
  • How to solve 0xc0000135 application errors after Windows 11 Update
  • How to get the integrity value for a jquery version of script reference in a web page
  • How to get session value in Javascript
  • How to get value from resx file in C#
  • How to lock the ciritical code part in C#
  • How to make theater mode the default for Youtube
  • How to turn off YouTube annotations and cards
  • How to hide Youtube chat windows permanently

Recent Posts

  • How to make the default class type ‘public’ instead of ‘internal’ in Visual Studio
  • How to put text inside MVC Razor code block
  • How to solve 0xc0000135 application errors after Windows 11 Update
  • How to get the integrity value for a jquery version of script reference in a web page
  • How to get session value in Javascript

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (333)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (223)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (191)
  • Find numbers with more than two decimal places in SQL (191)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (190)

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

powered by XBlog Plus WordPress Theme