Inserting '?' into a TD table

Analytics

Inserting '?' into a TD table

Hi all,

How do i insert the special character '?' into a table.

Thanks
Manjeet
3 REPLIES
N/A

Re: Inserting '?' into a TD table

If it is a real question mark:

Insert into Tbl
(CharField)
Values ('?')
;

If it is a real special character, you need to find the hex value of the character you want to set up. For Line feed (X'0A'):

Insert Into Tbl
(CharField)
Values ('0A'XC)
;

Re: Inserting '?' into a TD table

Hahaha,
Ok, if I have read this question correctly, Manjeet is actually refering to the SPECIAL CHARACTER "?" which you see in SQL Assistant. Manjeet, this is how a NULL value in a table is also represented in SQL assistant. But please note that even a CHARACTER "?" has the same representation. To avoid any confusions you can go to Tools>Options and choose "Show NULL Values AS" to "NULL" in SQL Assitant.
If you want to INSERT a NULL value to a Table, just try
INSERT INTO TAB A (COLUMN)
VALUES (NULL);

Re: Inserting '?' into a TD table

Hi all!

I've just visited this forum. Happy to get acquainted with you. Thanks.

__________________