Okey, I am with you.

Try using [] like this:

[*]



Hth,



Hakan



-----Ursprungligt meddelande-----

Från: Kevn77@a... [mailto:Kevn77@a...]

Skickat: den 17 augusti 2001 09:31

Till: ASP Databases

Ämne: [asp_databases] Re: SV: SQL Escape Characters...





In a message dated 8/16/2001 11:59:15 PM Pacific Daylight Time,

hakan@c... writes:





> Hi!

>

> You cannot use a select statement like that. You have to specify what

table

> you are getting your results from. Do you have a table called *? Rename it

> if so.

> Secondly, do you have a column in that table called "Word"? If so, I

suggest

> you rename it to something more specific. <That> looks like a HTML tag

that

> doesn´t exist..

> I suggest you look into some SQL books to get a more "firm" grasp of what

> SQL is about.

> Try this link: http://w3.one.net/~jhoffman/sqltut.htm

>

> Hakan



i need to get it from a table called "*" not from all the tables... and

stored in that table("*") are two fields....."Word" and "Template"



one of the recordsets has "<THAT>" for the "Word" field and something else

for the "Template" field.....



i need to select that table("*") and the recordset that has "<THAT>" in its

"Word" field....



this is the way i need to do it....



i know in Java you have escape characters like \'  or  \"  etc is there

something similar in SQL?? ie



SELECT * FROM \* WHERE Word = '<THAT>'