Todays Question
I want to check to see if a character in a particular word say PONTIFICATION has any thing other than alphabetical characters in it. For example say the word is PONTI&&***FIC)(ATION, I want to extract non alpha characters out of this. How would I do this in SQL? I can't find any sort of help in the help files.
Question 1
I'm trying to do a copy with a false condition to get all the rows into a new table but can't figure out the syntax
Isn't this supposed to be right?
Select * from Table_1
INTO Table_2
where 1 =2
Table_2 will therefore be created with all column headers but no actual data, which is what I want. I am getting a syntax error though.
Any help?
I want to check to see if a character in a particular word say PONTIFICATION has any thing other than alphabetical characters in it. For example say the word is PONTI&&***FIC)(ATION, I want to extract non alpha characters out of this. How would I do this in SQL? I can't find any sort of help in the help files.
Question 1
I'm trying to do a copy with a false condition to get all the rows into a new table but can't figure out the syntax
Isn't this supposed to be right?
Select * from Table_1
INTO Table_2
where 1 =2
Table_2 will therefore be created with all column headers but no actual data, which is what I want. I am getting a syntax error though.
Any help?