column accept hyphen or dot

Question

Hi,

We have requirement - the column should accept the hyphen(-) or dot.

The column data type is nvarchar.

Please let me know if it is possible.

Answer 1

Hi @Bilal H. Bhatt

Yes, it is possible.

Check this sample:

DECLARE @TBL TABLE (COL NVARCHAR(20))
INSERT INTO @TBL VALUES(N'AAA-BBB.CCC')
SELECT * FROM @TBL

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".