select SUBSTRING('uihghoehgoiegh',2,5) Name
OP: ihgho
First Letter of Each word :
CREATE FUNCTION dbo.fnFirsties
( @str NVARCHAR(4000) )
RETURNS NVARCHAR(2000)
AS
BEGIN
DECLARE @retval NVARCHAR(2000);
SET @str=RTRIM(LTRIM(@str));
SET @retval=LEFT(@str,1);
WHILE CHARINDEX(' ',@str,1)>0 BEGIN
SET
@str=LTRIM(RIGHT(@str,LEN(@str)-CHARINDEX(' ',@str,1)));
SET @retval+=LEFT(@str,1);
END
RETURN @retval;
END
GO
SELECT dbo.fnFirsties('Michael
Joseph Jackson');
SELECT dbo.fnFirsties(' Michael
Joseph Jackson '); -- multiple
space protection :)
Results:
MJJ
MJJ
Get Day Name:
select DateName(dw,'2015-03-09') as name
Results:
Monday
ALTER TABLE Emp_tb_att_RecurringHolidayCalenderDetail DROP COLUMN EventHeader ALTER TABLE Emp_tb_att_RecurringHolidayCalenderDetail add RWeek varchar(100) |
Sign up here with your email
ConversionConversion EmoticonEmoticon