Before I populate a VARCHAR field from a NVARCHAR field, I want to check if it is possible to do without raising an error.

Yes, precisely what I was after!

Many thanks!

🙂

How about this?

DECLARE @SubStringLength AS INT

SELECT STRING

FROM STUFF

WHERE ISNUMERIC(SUBSTRING(STRING,1,@SubStringLength)) = 1 -- Checks the substring is numeric

AND SUBSTRING(STRING,1,@SubStringLength) NOT LIKE '%.%' ...

Hi Andrew, thanks for the reply.

That's what I did in the end. I created 6 NT security groups, as follows:

G_SQL_PROD_SYSADMIN G_SQL_PROD_READONLY

G_SQL_DEV_SYSADMIN ...