Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can a wild card be passed through a fn_get statement?

Status
Not open for further replies.
JTORO

JTORO

Technical User
Dec 16, 2014
1
US
Example statement: is fn_get_s_nam_Pr_Sec(BASIC_MODULE."ID",BASIC_MODULE."CARE_EVENT",BASIC_MODULE."MODULE_ID",'*RNA',1,4)

is not returning anything. However, when I specify a letter, like "SRNA", it returns the name of people with that title.
 
Sort by date Sort by votes
I do not know the function. But it might be because you are using the wrong wild card. Try a %.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
185
hilfy
hilfy
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
253
jchewsmith
jchewsmith
J
  • Locked
  • Question
New page before when a detail section last on page.
Replies
1
Views
382
hilfy
hilfy
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
274
SarahSCPDAdmin
SarahSCPDAdmin
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
509
doodledump
D

Part and Inventory Search

Sponsor

Back
Top