Thank you. It works, with primary key in SQL server query, I can link to the query and insert or update data. Thuan Pham

Thank you for all your help.

Thuan Pham

I tried this charindex (char(10), street,2) and the function gives me the position of the new line character  but when the address has only one line, the function returns 0,...

Hi

Thank you for the suggestion, I tried it but MS SQL server doesn't like it, error message: The data type text is invalid for charindex function