There is a NTUsername object that you can trace using SQL Profiler which will display the Username for each connection to the SQL Server.

Maybe you could run a trace on...

Glenn,

I believe that they do need to do them separately - the original code I posted was the 'fundamentals' of the function which were simplified to highlight the validation error.

If...

That's a very good point Vladan - it will allow '400e5' and also '400d5' as I believe ISNUMERIC has limitations in it which are derived from a previous programming language...

Many thanks for all your suggestions - the outcome I have decided to take is to add the 'collate Latin1_General_BIN' and increase the size of @CharPattern as I believe that...

I have tried :

IF (ISNUMERIC (SUBSTRING (@ID, 1, 5)) = 1) AND (SUBSTRING (@ID, 6, 7) LIKE @CharPattern collate Latin1_General_BIN)

This returns the correct result in that it states the ID...

I have tried :

DECLARE @ID NCHAR(12)

DECLARE @CharPattern NCHAR (70)

SELECT @ID = N'40065*0â007d'

It still returns that the value is valid when it is not.

The collation on the database is Latin1_General_CS_AS....

 The file is created using a program that was written in Delphi and below is an example of the first record in the file. 

H1Ô  0504151427505479150405©   º  í

The rows are...

CREATE TABLE

  ##Tmp1

  (

    MyText TEXT

  )

DECLARE @Cmd VARCHAR(100)

SET @Cmd = 'BCP ##Tmp1 IN "file details" -T -c -r "##~~##~~##"'

EXEC master.dbo.xp_cmdshell @Cmd, NO_OUTPUT

This is the only way that I could get...