sql server reporting services: need to select the first two letters of a string in a text box -- sql server reporting services

need to select the first two letters of a string in a text box

Susan R
3/26/2006 3:32:02 PM

sql server reporting services:

HI,

I have a form that has a text box where there is a street address populated
when the form is run. LEts call it textbox 1.
I need to add logic that if the first two letters in the string in textbox 1
are PO or P.O. then populate the informaton in box 2.
Any help would be appreciated.

RE: need to select the first two letters of a string in a text box

Amarnath
3/26/2006 8:46:02 PM

Hi Susan,
This Expression should be in box 2.
= iif((left(streetaddress,2) = "PO" or left(streetaddress,4) = "P.O."),
<populateinfo>, Nothing)

This should work.

Amarnath

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.