query to query

Question

it is more complicate to describe why i have to do this but it's the only way just an example below.

My query to give me anthing from the table when i do the query to query to get what i want but when i use the left string function then i got an error below.

Query Of Queries syntax error.

Encountered "left. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,

thanks

select * from [dbo].[requestType]

</cfquery>

results look like

type:

=====

ADD

REMYU

RECD

I want to do the query to query to get the REMYU

select * from type

where left(type,3) = 'rem'

</cfquery>

Carl Von Stetten · Answer

The left() function is typically a SQL function, and is not available in Query-of-Query syntax. You could rewrite your first query to be more specific:

select * from [dbo].[requestType]

where left(type,3) = 'rem'

</cfquery>

Otherwise, you could use the LIKE operator instead:

select * from type

where type LIKE 'rem%'

</cfquery>

-Carl V.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded