Thanks Chris...how odd! I've tested it here several times...

Interesting...it works with the (albeit limited) set of...

-- Create a function

CREATE FUNCTION [dbo].[uftSortString]

(

@String NVARCHAR(100)

)

RETURNS NVARCHAR(100)

AS

BEGIN

DECLARE @ReturnValue NVARCHAR(20)

SET @ReturnValue = ''

SELECT @ReturnValue = @ReturnValue + d.TheValue

FROM (SELECT TOP 100 PERCENT CAST(SUBSTRING(@String,number,1) AS CHAR(1)) AS...

Hello

You want to sort the data in the string, as opposed to sorting the column.

So the value '132' becomes '123' etc

What is the maximum length of string values found in...

It's still really difficult to tell what's supposed to be happening here because the use of variables doesn't necessarily make any sense. It would help people a great deal if...

You need a BEGIN / END block between IF and ELSE if the IF is followed by more than one statement.

Yep:

SELECT i.*

FROM #InventoryStage i

INNER JOIN (SELECT...

Hi Jeordonez

A picture tells a thousand words...

CREATE TABLE #InventoryStage(

[SerialNumber] [varchar](20) NULL,

[TagNumber] [varchar](8) NULL,

...

DROP TABLE #Dates

CREATE TABLE #Dates (CreateDate DATETIME)

INSERT INTO #Dates (CreateDate)

SELECT '01/01/2008' UNION ALL

SELECT '02/01/2008' UNION ALL

SELECT '03/01/2008' UNION ALL

SELECT '04/01/2008' UNION ALL

SELECT '05/01/2008' UNION ALL

SELECT '06/01/2008' UNION ALL

SELECT '07/01/2008' UNION...

You're welcome :unsure::ermm:

declare @Return varchar(30), @String varchar(30)

set @Return = ''

set @String = 'CHARLES H#L6CAL JOEL4'

SELECT @Return = @Return + SUBSTRING(@String,number,1)

FROM dbo.Numbers WITH (NOLOCK)

WHERE number <= LEN(@String)

AND UPPER(SUBSTRING(@String,number,1)) LIKE '%[^A-Z]%'

SELECT CASE WHEN...

How about a little more information? What do you want to do if the string contains something other than a letter? Such as

report an error

not import the row into a...

You're welcome Jude, thanks for the feedback 🙂

Test the SELECT on its own:

SELECT c.academic_year, c.faculty, c.faculty_description, c.department_code,

c.department_description, c.course_level_code, c.location_of_study, c.location_of_study_description,

c.franchise_flag, c.source_of_funding_hesa, c.Residential_Status_Code, c.residential_status_description,

c.Course_Code, c.course_mode_of_study_hesa

FROM tblStudent_Course c

INNER JOIN tblNew_Entrants n

...

Hi Jude

Can you please post the code you ran, with the error message?

Please also post:

The list of columns you want populated in the registration table

The list of columns from the...