Hi,

I have a custom object Store with custom field StoreNumber.

The properties of StoreNumber Field are: Text(4) (External ID) (Unique Case Insensitive)

Now,I have a store data with StoreNumber = '0059'

Whenever I perform a query like following, it doesn't return me any result

Select s.StoreNumber__c, s.DistrictNumber__c From Store__c s
where s.StoreNumber__c = '0059'

However, if I perform a query like following, it does return me the values including the value for StoreNumber 0059.

Select s.StoreNumber__c, s.DistrictNumber__c From Store__c s
where s.StoreNumber__c >= '0059'
order by s.StoreNumber__c

Why is it not returning me the value with earlier query 'equals' ?

ANy help will be greatly appreciated.

THanks

Hi,

I have a custom object Store with custom field StoreNumber.

The properties of StoreNumber Field are: Text(4) (External ID) (Unique Case Insensitive)

Now,I have a store data with StoreNumber = '0059'

Whenever I perform a query like following, it doesn't return me any result

Select s.StoreNumber__c, s.DistrictNumber__c From Store__c s
where s.StoreNumber__c = '0059'

However, if I perform a query like following, it does return me the values including the value for StoreNumber 0059.

Select s.StoreNumber__c, s.DistrictNumber__c From Store__c s
where s.StoreNumber__c >= '0059'
order by s.StoreNumber__c

Why is it not returning me the value with earlier query 'equals' ?

ANy help will be greatly appreciated.

THanks

I tried my best searching for something like this. Sorry if this is a respost.

I've got this inline visualforce page embedded in my Opportunity Page. Does anyone know how to get rid of the border that's produced when using this code below. The pageblock adds the a border that the title would typically sit inside. I want to be able to use the pageblock tag without having any borders. Can I get rid of those yellow borders ? Thanks in adv

<apex:page standardController="opportunity" extensions="OppSearchExt" >

<apex:form>
        <apex:pageBlock mode="edit"  >

        </apex:pageBlock>

</apex:form >

</page>