|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/15/2009 10:40:50 AM
Posts: 2,
Visits: 5
|
|
Hi all,
How do i insert the special character '?' into a table.
Thanks
Manjeet
Regards
Manjeet
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 3:55:54 AM
Posts: 111,
Visits: 263
|
|
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)
;
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: Yesterday @ 12:42:08 AM
Posts: 74,
Visits: 32
|
|
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);
Strive to success. Arun.
|
|
|
|