Thanks for the SQL that tells me about the tables not having a FK relationship. Here are the results. There are 107 tables with no foreign key. Now I am...

bitbucket-25253, Thanks for your post! Let me know if this is asking to much but can you explain the stored procedure? I did try it on the Northwind database and...

It looks to me as if he is trying to replace the zeroes with a space and then trim off the space and then replace the space with a 5....

Steve I am new to this forum and to ms sql. When you said post the DDL for the table, can that be done by right clicking the table and...

J-F,

Thanks for the push. I went and looked again at the post from Lowell and with you help was able to move forward. Thanks again. Sorry lack of confidence is...

You're right. I am sorry. I have a tough admitting I do not understand something. With your solution, J-F Bergeron, I have no idea how to adapt it to...

Here is an example of my results with my T-Sql:

SELECT CHARINDEX('4', Amount, 1) AS Length, Amount, EnrollmentYear, CHARINDEX('4', SSN, 1) AS Expr1, CAST(Amount AS varchar(50))

...