Looking for an Expression for a Query 1

[achiola]

I am looking for an expression in a Query that will look at a particular field, analyze the data and return a particular statement. For example:


Field 1

GLP002
GRS003
GLP004
TRE445

I want an expression that will look at this feild for the data types beginning with "GLP..."and return the word "hardcoded" in the field adjacent to it when it finds it.

Field 1 Field 2

GLP002 hardcoded
GRS003
GLP004 hardcoded
TRE445

Can anyone help?

Nino

 

[tlbroadbent]

Use the IIF funtion.

IIF([Field 1] Like "GLP*","Hardcoded","&quot As [Field 2] Terry

http://members.home.net/tlbroadbent/index.htm

 

[Cagliostro]

function:
function xxxx(x as string) as string
if x like "GLP*" then
xxxx = "hardcoded"
else xxxx = ""
end if
end function
query:
select Field1, xxxx(field1) as field2 from YourTable
John Fill

ivfmd@mail.md

 

[tlbroadbent]

John,

Why write a function when IIF already exists? Terry

http://members.home.net/tlbroadbent/index.htm

 

[achiola]

Thanks that was a big help everyone!

 

[Cagliostro]

I'm not so familiar with VB and do not know what is IIF for. My current programming environments are C++ and SQLServer. John Fill

ivfmd@mail.md

 

[Cagliostro]

By the way, have you forgotten so fast about 'in(...)'? John Fill

ivfmd@mail.md

 

[achiola]

Terry,

I do apologize, but I thought your if statement would work but for some reason it is not. I can't figure out why?

Nino

 

[tlbroadbent]

What is the problem? Do you get an error or does it just return incorrect results? Terry

http://members.home.net/tlbroadbent/index.htm